G Guest May 13, 2007 #1 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?
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?
G Guest May 14, 2007 #2 You should post your sql to get an accurate reply. However, try wrap your Value in: Val(Nz(Count([FieldName]),0))
You should post your sql to get an accurate reply. However, try wrap your Value in: Val(Nz(Count([FieldName]),0))
