I am very new to Access. I have 2 tables. One has invoice info, the other payment info. Inv table has customer numbers that might appear several times on diff invoices. Ex Cust A, Inv1 $20, Inv3 $10. The Pmt table has customer numbers that appear only once with a total $ amt for multiple inv. Cust A $30. I want to combine tables with results showing me the $amt received for each customer. These table are created in Excel and imported into Access. When I run a query my line count and $$ amounts are increased. What am I doing wrong??!