Returning a Zero in a Query

  • Thread starter Thread starter Debbie Nelson
  • Start date Start date
D

Debbie Nelson

I'm running a query that totals MTD sales for a
particular time frame and by a sales district. The query
lists sales by district and then ranks the districts. If
there are no sales in a district how can I get the query
to return a zero? I tried to use an IIF statement but am
not sure now to test for a null field.

Thanks

Debbie Nelson
 
I'm running a query that totals MTD sales for a
particular time frame and by a sales district. The query
lists sales by district and then ranks the districts. If
there are no sales in a district how can I get the query
to return a zero? I tried to use an IIF statement but am
not sure now to test for a null field.

Thanks

Debbie Nelson
Click to expand...

Look up the Nz function in VBA help.
=Nz([Field1],0), + Nz([Field2],0) + etc.
or
= Sum(Nz([FieldName],0))
 
Back
Top