I have tables in Access linked to Excel where I enter my data. One of my tables is a list of payees and invoices. One table (my downloaded bank statement) is a list of payees and payments.
I want to see a result which shows a list of payees (grouped by payee) each followed by a list of invoices and amounts and a list of payments and amounts so I can see who owes me money.
When I try this Access returns all combinations of invoice amounts and payment amounts which is very unhelpful.
Can any body advise if there is an easy way round this please.