Convert Null to Zero

  • Thread starter Thread starter Chris Kudron
  • Start date Start date
C

Chris Kudron

I have a query that counts deficiencies found, items
complete and open items. I also want to add a field that
contains the number of items completed during a time frame
specified.

Everything in the query works if there was something
completed in the time frame specified, if there was
nothing completed in the time frame specified I want the a
Zero to come back. Currently nothing comes back.

Example Deficiencies found 100, Items Complete 90, Open
Items 10, Items complete from 1/1/04 - 1/15/04 (90 or zero
or whatever the quantity is).
 
Back
Top