P
Philip Burns (UK)
I have tables for purchases with fields
Supplier
Purchaser
Product
Quantity
Price
and a table for payments with fields
Supplier
Purchaser
Payment
Payment Date
I want to run a query and/or report to show Supplier, then
Purchaser(grouped), purchases (ie Price*Quantity Summed), and Payments, but
when I do the result is that every record in the purchases table is shown
once for every record in the payments table
example: a purchaser has bought items for £10 (one record in the purchase
table) and has made one payment of £10 (one record in the payments table). My
query returns two records each showing both the £10 purchase and the £10
payment, therefore giving totals of £20 for purchases and £20 for payments
Where am I going wrong?
Supplier
Purchaser
Product
Quantity
Price
and a table for payments with fields
Supplier
Purchaser
Payment
Payment Date
I want to run a query and/or report to show Supplier, then
Purchaser(grouped), purchases (ie Price*Quantity Summed), and Payments, but
when I do the result is that every record in the purchases table is shown
once for every record in the payments table
example: a purchaser has bought items for £10 (one record in the purchase
table) and has made one payment of £10 (one record in the payments table). My
query returns two records each showing both the £10 purchase and the £10
payment, therefore giving totals of £20 for purchases and £20 for payments
Where am I going wrong?