Balance Queries

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

Guest

I need to set up a query showing name, an amount charged, payment recieved and the balance after the payment is recieved. I found the following formula that would seem to fit, but can't work out where to actually put it

Newfield:[Field1] + [[Field2]

This would seem to fit what I what like to do, and I presume I'd change the field names to 'Balance', 'Charges', and 'Payments'. I'm fairly sure the answer is pretty easy & that I'm overlooking something, but I would appreciate any help
Many thanks
 
Hawkeye,

If you use the query design view, you can make a query based on your
existing data including charges and payments, and then enter the
expression you mentioned into the Field row of a blank column in the
query design grid. Probably be...
Balance: [Charges]-[Payments]
or, if there is a chance that there are no payments and the Payments
field is therefore empty, you should use...
Balance: [Charges]-Nz([Payments],0)
 
Back
Top