NOT having information repeated multiple times in a report

  • Thread starter Thread starter Susan C. Holt
  • Start date Start date
S

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.
 
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.
 
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.
 
Remove one of the tables from the report's record soruce and use a subreport.
--
Duane Hookom
Microsoft Access MVP






- Show quoted text -
Click to expand...

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.
 
Back
Top