how do I eliminate duplicate records when querying from several t.

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

Guest

I am using access 2000. I created a query that pulls info from 4 different
tables. I am trying to create a report that lines up the related records,
ACROSS the page. I have set the field properties to "hide duplicates" however
I still receive duplicates in the report.
 
there should be two ways
1. Group by your Recordsource.
2. On the Grouping and sorting property, choose GroupOn
and KeepTogether
 
Back
Top