Null Values in a Query

G

Guest

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
 

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

Ct:1 Appears in Left Join for all values rather than selected valu 1
Conditional Expression 5
Count and sum per month in a query 2
update form on change of field used in expression 1
NOT function not working - can prove with screenshots 1
Query filtering in Access 2007 not the same as 2003? 1
Sorting by month field 1
Set default to zero instead of Null 3

Top