Duplicate records in report

  • Thread starter Thread starter BigK9
  • Start date Start date
B

BigK9

I have a daily sales report which is built from a query pulling from 5
tables. I built a report based on the query and am only grouping on the
"payment date" field from one of the tables. Here is my
problem...........when I run either the query or the report.........some of
the records are being duplicated. Not all, but only some. I'm lost!
 
Look at your report's RecordSource query in datasheet view; I'm sure that
you'll see the same duplicate records there, too. This duplication is caused
by one of the tables being joined having more than one record for a matching
record in a table to which it's joined. Likely, you'll need to replace that
table that contains the multiple records with a query that returns just one
record for each matching item, and then you'll be ok.
 
Back
Top