i want to calculate a field in a query cost - refund = claim

C

Co

I have tried to do this but it will not work. the fields are all in the same
database and i would like to have the answer appear automatically in the
window as the other fields are entered
 
G

Graham Mandeno

Hi Co

In the top row of an empty column in your query grid, enter:

claim: [cost] - [refund]

That should be all you need.
 
Top