I have set up a delete and append query to eliminate duplicate client I'd numbers using the primary key and this works fine if am running the report for just one month. However if I want to run the report for three months the report and if there is a transaction with a client for the three month the report will only pull through one of the client ID's. I want the report to pull through the client I'd's for each of the month if there is a transaction.
Help with duplicate query
- Thread starter Nancyade
- Start date
