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