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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
How do I freeze the swimlane headers? 0
Blank or Null in a Cross Tab Query in Access 2003 2
Viso Wizard no launching? 0
Adding sequence numbers to paragraphs 0
Can't seem to delete all images from a Word Doc 2
One note creating multiple tabs when collaborating? 0
Cross Tab Report Vs Dynamic coulmns 0

Top