It would help if you provided all the relationships. I expect you have one
main table related to two other tables. I expect the other two might not be
related to each other. If this is the case, you may need to place one or both
of the other tables in a subreport.

--
Duane Hookom
Microsoft Access MVP


"Susan C. Holt" wrote:

I'm sure there is a "kick myself" answer for this question.

I have created a project report in Access 2007. The query consists of three
tables: Project, Principle Investigators, and Activity. The problem I am
running into is that I am using "Statistician" from the Activity Table and
I'm getting repeats of the project names (I enter hours in the activity table
so the Statistican's name appears multiple times) I want to use the
information from Activity because it allows me to print a project list for
each statistician (there could be several on one projects) How do I limit the
report to print each project once? I'm sure there is something simple I'm
missing.