No totals from empty fields

[MarkRind]

I have created a an invoice db. There are 4 separate departments that have to bill the customer. Not every department bills every customer, so sometimes I have "empty" fields in my querys. My totals will not appear unless every department looks at every invoice. Is there a way to total with out having to have a value in a field?

 

[Rich]

Look up the Nz function

 

[MarkRind]

Thanks for that, but how do I use that in a query, or do I ned to write code. I am not expert enough to do that.



[This message has been edited by MarkRind (edited 04-19-2002).]

 

[DJN]

Mark. Place NZ in front of the field name in the calculated field. e.g.
Invoice Amount :NZ([FieldName])
If say, you are adding the results of fields, just place NZ in front of each field.
e.g.
Invoice Amount:NZ([FieldName])+NZ([FieldName2])
Hope that helps

David

 

[Jerry Stoner]

Dont you really mean
NZ([FieldName],0)?

 

[MarkRind]

Thank you, that did it.
ps I didn't need the ",0" when I used it in the query