A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

NOT having information repeated multiple times in a report



 
 
Thread Tools Display Modes
  #1  
Old December 14th, 2009, 09: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.
  #2  
Old December 15th, 2009, 05:06 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old December 15th, 2009, 04:09 PM posted to microsoft.public.access.reports
Susan C. Holt[_2_]
external usenet poster
 
Posts: 1
Default 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  
Old December 16th, 2009, 12:21 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old December 18th, 2009, 07:18 PM posted to microsoft.public.access.reports
Susan[_10_]
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.