View Single Post
  #1  
Old December 14th, 2009, 08:46 PM posted to microsoft.public.access.reports
Susan C. Holt
external usenet poster
 
Posts: 1
Default NOT having information repeated multiple times in a report

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.