report query question

[default105]

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.

 

[Jeff Boyce]

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

 

[default105]

Thanks

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