Query problem when adding two fields

[Guest]

I have an access database with 2 fields, one is a beginning balance the other
is adjustments. The sum of beginning balance +/- adjustments is my ending
amount.

My problem is when there are no adjustments (ie the adjustment field that
day is blank) the query returns a blank field for that day instead of just
returning the beginning balance. How do I set it so the query basically
would take beginning balance +/- nothing (blank field) and return the
beginning balance?

Thanks

 

[Guest]

Replace your adjustments field with Nz([AdjustmentsField],0).