Blank or null = 0

[Tuckejam]

I apologize this is probably a common question and the answer is probably NO.

But I am having problems doing math in a qry

PastDue: [DuesOwed]-[DuesPaid]

PastDueFines: [FinesAssessed]-[FinesPaid]

TotalOwed: [DuesOwed]-[DuesPaid]+[FinesAssessed]-[FinesPaid]

if I have a value in [DuesOwed] and nothing, Null, Blank in [DuesPaid] it wont do the math

I have to have a 0 in every field where there is a blank to get the calculations to work.

is there a way to write the expresion to accept null as 0

and if not is there a quick and easy way to go back through 400 rows of data and enter all the 0s



thanks for the help

[isladogs]

The answer is YES
Use Nz(expression,0)

[June7]

If you want any Null to be treated as 0 so fields with number will still add up, enclose each field in Nz() function

Nz([DuesOwed])-Nz([DuesPaid])+Nz([FinesAssessed])-Nz([FinesPaid])

Otherwise, use Find/Replace to populate all Null fields with 0.