Query total amount

[Jimmy]

Hi, everyone

I have two tables

Table A

Invoice Amount

12 100
13 200
14 250
15 250

Total $800

Table B

Pinvoice Pamount Pdate

12 100 1/8
13 100 3/8
13 100 10/8
14 250 11/8
15 100 20/8
15 150 31/8

I created a query match Table A and Table B based on Table A source, the
result was as below
and then export to excel

Invoice Amount Pinvoice Pamount Pdate
12 100 12 100 1/8
13 200 13 100 3/8
13 200 13 100 10/8
14 250 14 250 11/8
15 250 15 100 20/8
15 250 15 150 31/8
Total $1250

The problem : total amount of Table A($800) is a difference with Query
result ($1250)

Any help is appreciated

Thanks
Jimmy

 

[Golfinray]

Normally, I find it better to start a new query, put the one field in that
you want totaled, do the sum function which should give you an accurate
total, and then call that one field back into your query with the total.