Hello

I have this simple query that either displays a value or can be null,

SELECT [Quaterly total number of workshops aberdeen].CountOfTown
FROM [Quaterly total number of workshops aberdeen];

Having read about the NZ function I would like to display a 0 if is
null.  So I tried this

SELECT Nz([Quaterly total number of workshops
aberdeen].[CountOfTown],0) AS Expr1
FROM [Quaterly total number of workshops aberdeen];

but it doesn't return a 0,

could someone tell me what Im doing wrong, or even how to do it right

Thanks for nay help in advance

Mat