Nz not working in a cross tab

[The T]

Have a query that returns blanks, want it to return zero's; the field
I'm counting on is an autonumber:

I've tried Expr1: Nz([idcardiotype],0) and Expr1: Nz([idcardiotype],0)
neigher works, what am i missing

 

[John W. Vinson]

Have a query that returns blanks, want it to return zero's; the field
I'm counting on is an autonumber:

I've tried Expr1: Nz([idcardiotype],0) and Expr1: Nz([idcardiotype],0)
neigher works, what am i missing

Please post the complete SQL of the query, and indicate what you are in fact
getting. What's idcardiotype? Why would it be NULL (an Autonumber will never
be)? What do you expect to see?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com