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. |
#2
|
|||
|
|||
NOT having information repeated multiple times in a report
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. |
#3
|
|||
|
|||
NOT having information repeated multiple times in a report
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" wrote: 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. |
#4
|
|||
|
|||
NOT having information repeated multiple times in a report
Remove one of the tables from the report's record soruce and use a subreport.
-- Duane Hookom Microsoft Access MVP "Susan C. Holt" wrote: 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" wrote: 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. |
#5
|
|||
|
|||
NOT having information repeated multiple times in a report
On Dec 15, 6:21*pm, Duane Hookom
wrote: Remove one of the tables from the report's record soruce and use a subreport. -- Duane Hookom Microsoft Access MVP "Susan C. Holt" wrote: 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" wrote: 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. *- Hide quoted text - - 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. |
Thread Tools | |
Display Modes | |
|
|