Zero instead of null

S

SHIPP

I have created a cross tab query with a count. How do I get the cross tab
query to display 0 instead of a blank and/or null?
 
D

Duane Hookom

You should post your sql to get an accurate reply. However, try wrap your
Value in:
Val(Nz(Count([FieldName]),0))
 
Top