repeat a column onto another page


N

NTatuo

I have a report that I am using that is too big to fit on a legal size sheet
of paper. I would like the employee name from the first page to carry over to
the second page so that we can see who has attended the classes that are
listed. How can I make the name field repeat?
Thank you any help would be greatly appreciated
 
Ad

Advertisements

F

fredg

I have a report that I am using that is too big to fit on a legal size sheet
of paper. I would like the employee name from the first page to carry over to
the second page so that we can see who has attended the classes that are
listed. How can I make the name field repeat?
Thank you any help would be greatly appreciated
Have you grouped the report by Employee?
If so set the Employee Group's Repeat Section property to Yes.
It's on the Property Sheet's Format tab.
 
N

NTatuo

No I have the employees grouped by there dept number. Currently we track 20
training sessions and I can only fit 12 on a page so the other 8 sessions are
reported but they are not attached to anyone.
I maybe in over my head on this one as I have been looking for the repeat
section to change to yes but can not find it???
 
J

John Spencer

So add another group and group by the employee. Then in the group header you
can put the information you want to repeat.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
N

NTatuo

I tired that but the name field still does not appear on the next page.
 
J

John Spencer

Did you set the Group's repeat section property to Yes (True)?

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Ad

Advertisements

Ad

Advertisements

J

John Spencer

Well, I can't figure out why this doesn't work.

It should. Obviously you are doing something that I am missing or there
is something in the setup of your report that is different than what I
expect.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top