NOT having information repeated multiple times in a report

[Susan C. Holt]

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.

 

[Duane Hookom]

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.

 

[Susan C. Holt]

All tables are linked by the ProjectID. I think the problem is that in the
Activity Table, the ProjectIDs are repeated because that's where I enter the
hours worked on the project and the Statistician that worked them. I'm not
sure how to overcome this problem.

 

[Duane Hookom]

Remove one of the tables from the report's record soruce and use a subreport.

 

[Susan]

Remove one of the tables from the report's record soruce and use a subreport.
--
Duane Hookom
Microsoft Access MVP






- Show quoted text -

Thank you, that worked. I just set up the "hours" to be totalled and
summarized and I was able to generate a report without duplication.
Thanks for the suggestion.