New Page for each Employee ID 1

[BakerUSMC]

Hello to all!!!

I am sure this is a simple and easy question but I just can't figure it out. Please help!!!!!

I have a report based on a query. The query has the following fields:

Employee ID
School Name
Address
City
State
Zip
Year Attended

What I am trying to do is create a report where Each Employee ID will be on its own page. Sometimes there will be multiple records for each Employee ID. I don't know how to force a new page for each new Employee ID and keep all their records grouped together.

I have tried sorting and grouping but it just doesn't seem to work for me. Could someone please me with this??!!

Thanks

 

[THWatson]

BakerUSMC
I think you're on the right track with the Sorting and Grouping.

Use the Employee ID as the field by which to Group. You will have to set the Group Footer to Yes, maybe the Group Header as well. Experiment with that part. Whichever setting works, check Keep Together Whole Group.

On your report, click the Group Footer, and in the Properties set Force New Page to After Section.

See if that works.

Tom

 

[BakerUSMC]

Tom,

Thanks for your quick response and your awesome info. I had the group header but totally forgot the group footer and Force new page to after section. It works beautifully!!

Thanks again!!!!!

 

[THWatson]

You're welcome!
Tom