Question Null Values

[jc_]

If I have a null value, but I want to put a $0.00 in the cell, what formula should I use? Ive been trying to use the nz and iff functions but i havent been able to get it right.. im using a query to list total cash receipts by account. i have the cashacctnum the accttype and the receiptamount. some of the receipt amounts are empty but i want it to say $0.00

 

[Beetle]

If the data type of the ReceiptAmount is Currency, then;

Nz([ReceiptAmount], 0)

in a caculated field in the quert should do the trick.