repeating records

jeo

Registered User.
Local time
Today, 23:05
Joined
Dec 26, 2002
Messages
299
I’m trying to create a report with a subreport. Main report is a Project report, with project info and subreport is a staff report tied to that project. I linked by Project_ID which is a PK in my main report and FK in my subreport. What I need help with is that I get duplicates of the main report for each staff person. If there are 4 people working on a particular project, I get 4 of the same pages of this report and I only want 1.
What am I doing wrong?
Thank you.
 
It sounds like you need a group header for the Project and then you should only get one page for each project.
 
Thank you, that worked.
I did have a relationship between project tbl and staff tbl in my main report query.
 

Users who are viewing this thread

Back
Top Bottom