Problem with subtracting amounts

  • Thread starter Thread starter Jean du Plessis
  • Start date Start date
J

Jean du Plessis

Hi all,

I have to tables. One table hold amounts to be invoiced and the other table
hold amounts already invoiced together with a linked field in bouth tables.
My problem is that I whant to creat a query that only shows the the amounts
from tabel1 that has not been fully invoiced acording to table2. I hope you
can help me accomplish that.

Thanks to everyone.

Jean
 
Can you provide more information about the table layouts.
It is hard to tell from your description whether these
amounts need to be summed or whether they exist on single rows.

Gerald Stanley MCSD
 
Back
Top