Hello, I have a query that links me to two tables, the first contains the identifiers of the people and a field of the purchase they have made, in the second table I have descriptions of the data including the value of the product and a client field, so that I link by client. The problem is that I see a client who has made two purchases of different amounts and appears 4 times as the records would appear:
Purchase1 - purchase1 \ Buy1 - Buy2 \ Buy2 - Buy1 \ Buy2 - Buy2
My problem is that I can not also group for money because maybe I have another record of the same person who has bought 1 thing in two installments and if I grouped by money this person would not appear because although the total does match amounts not since you have paid in installments.
What I would look for is that all the records appear and those that are repeated appear only those that go with the respective purchases.
I'm with ACCESS 2010
Thank you very much for the help. A greeting.