X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Nz Not Working In Access 2016, Access 2016    
post Aug 24 2019, 10:01 PM

Posts: 11
Joined: 22-July 12

I tried using the following on a different computer with Access 2013 however when I use it with 2016 I get an error - Undefined function "Nz" in expression
How can I replace the Nz function to make this work with various versions of Access?

The column comes up blank and I need a zero

TRANSFORM NZ(First([Attendance Query prep].Count)) +0 AS FirstOfCount
SELECT [Attendance Query prep].[Start Date]
FROM [Attendance Query prep]
GROUP BY [Attendance Query prep].[Start Date]
PIVOT [Attendance Query prep].Label In ("MCadetP","FCadetP","MCadetA","FCadetA","MCadetE","FCadetE","MStaffP","FStaffP","MStaffA","FStaffA","MStaffE","FStaffE");

Thanks in advance
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    18th October 2019 - 06:10 AM