Query problem when adding two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top