I've writting a query that counts items in a list, if a particular column has nothing to count, it skips that summary in the results of the query. How do I include the zero count items as well?
Novice
Windows Vista 
Access 2007
I've writting a query that counts items in a list, if a particular column has nothing to count, it skips that summary in the results of the query. How do I include the zero count items as well?
Competent Performer
Windows Vista Access 2007
How are you using the query. A Null can mean zero, but not always. Note the NZ function, e.g. NZ(ANullField)=0 and NZ(Null)=0.
Posting Permissions
Reply With Quote