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

F

fairxchg1

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.
 
O

Ofer

there should be two ways
1. Group by your Recordsource.
2. On the Grouping and sorting property, choose GroupOn
and KeepTogether
 
Top