Null Values in a Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cogaman - 12 Sep 2007 21:18 GMT

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?

Reply to this Message

Jeff Boyce - 12 Sep 2007 22:26 GMT

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

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

Reply to this Message