Null Values in a Query

C

Cogaman

I have a query that counts the number of times a person sells a spcific unit
number. What I want it to do is assign a zero value to anyone who does not
have that unit number sold in a one month period. How do i do that?
 
J

Jeff Boyce

Without some idea of how your data is organized, we can only offer broad,
general suggestions. Everything starts from the data ...

Take a look at the Nz() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top