My Access report is duplicating results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report is pulling data from two tables and two queries. The Sales
Person's name appears in all of these. When I run the report, the sales
person name will be repeated, with the same data. How do I eliminate the
duplicates?
 
Hi AliGoLightly,

Eliminate the duplicates by grouping the data by Sales Person name. That
way you have one heading with multiple rows of data...

Of course, if you are ending up with a cartesian product (ie: a record for
every record in every table), you need to link your tables together so that
Access knows which records are valid and which aren't.

Finally, you could always switch on grouping in the query that you are using
to power the report so that any rows that are returned that are truly
identical will be reduced to a single row.

Hope this helps.

Damian.
 
Back
Top