report query question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

default105 - 20 Oct 2007 00:43 GMT

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.

Reply to this Message

Jeff Boyce - 20 Oct 2007 00:49 GMT

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

>I want to make a report based from a query. The problem I keep running
>into
[quoted text clipped - 4 lines]
> two
> foreign tables. How do I get around this? Thanks for your help.

Reply to this Message

default105 - 20 Oct 2007 00:55 GMT

Thanks

> You don't! Let the query return all the "duplicates".
>
[quoted text clipped - 17 lines]
> > two
> > foreign tables. How do I get around this? Thanks for your help.

Reply to this Message