If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|