Duplicate records in report

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!
 
K

Ken Snell \(MVP\)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Records in a report 4
Show one report per customer if multiple sales 0
Summary Report 3
Reports that sift records from different tables 0
Coordinating the sort order in a report with the underlying query 2
Number of records in a group - Access 2003 2
Including query dates in report 1
Records Disappear in Blank Query 3

Top