Nz not working in a cross tab

  • Thread starter Thread starter The T
  • Start date Start date
T

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
 
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
Click to expand...

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
 
Back
Top