report query question

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

Guest

I want to make a report based from a query. The problem I keep running into
is the information in the query comes from three different tables linked by a
primary foreign key relationship. When I run the query I am getting
duplicate information because there is more than one entry in each of the two
foreign tables. How do I get around this? Thanks for your help.
 
You don't! Let the query return all the "duplicates".

In your report, you can use "Group By" to organize the report into sections
and not have to show the repeated values.

Or you can set the Hide Duplicates property of controls in a section so as
not to see those duplications.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks

Jeff Boyce said:
You don't! Let the query return all the "duplicates".

In your report, you can use "Group By" to organize the report into sections
and not have to show the repeated values.

Or you can set the Hide Duplicates property of controls in a section so as
not to see those duplications.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top