Wanting the report to have one employee per page

[LanieB]

I have a
Views: 6 Size: 448.0 KB">Example.accdb

Summary of the situation
I have one branch with multiple employees.
Each one of these employees gets audited on multiple files.

I'm trying to create the 'Audit Request' report which I will pull on a 'per branch' basis, but I want each employee to have their own page listing only the files they are being audited on. Everytime I run my report it pulls one employees name with all the files requested for the entire branch. I can't seem to get it to break it down. I do have this report on a 'per employee' basis that works fine, but I need to be able to pull the entire branch all at once with each employee seperated out.

I have attached an example below that has the necessary information to see my condundrum.

The parameters you will need to know to access the queries and report are

Audit Session: 13s
Branch Number: 01

I would GREATLY appreciated any advice! Thank you~

[June7]

Create a GROUP section by UserName. Set the GROUP section ForceNewPage property to AfterSection.

[LanieB]

Create a GROUP section by UserName. Set the GROUP section ForceNewPage property to AfterSection.

As always June, thank you very much for your help!! It worked perfectly!

[DariusD]

June I tried to follow your suggestion but I need help
June your wrote "Create a GROUP section by UserName. Set the GROUP section ForceNewPage property to AfterSection."
So I started Report wizard then set the group by order number but I can not find any option to ForceNewPage property to AfterSection.
I'm trying to create a report similar to my form shown below

[June7]

ForceNewPage property is on the Format tab of the Property Sheet dialog. Every section except Page header/footer has this property.

[DariusD]

I found the Property but it didn't work.. must be something wrong with the way i set up my report. I have it group by order number.

This is how it looks now.. I can't seem to make it show one order - order report per page.

[June7]

I would have to review the db. If you want to provide, follow instructions at bottom of my post.

[DariusD]

Sorry but I cant seem to make a copy.. Now when ever I try to saveas.. it keeps saying that the database is already open..see pic attached below.. I have done this before. with no problems. but now it refuses to let me save it again with a different name..

[DariusD]

Ok here you go the database is attached here
STEMProjectDatabase1.zip

[June7]

That isn't the database file. It is the locking file (.laccdb file extension) created by Access when the database is opened.

[DariusD]

STEMProjectDatabase1.zipAccessProject.zip
If neither of these is a database then i don't know what to do about it. Everytime I try to saveas the database it just keeps telling me that the database is open etc...

[June7]

The second link has a db named CopyofOrderEntryProject.accdb.

I see the same tables and forms (different query) as in your image but there are no report objects in that db.

Why are you using SaveAs?

[DariusD]

Im doing that to save a copy of the database to send to you...

[June7]

If you SaveAs to a different filename then should not error. However, the db you provided does not have any reports.

You don't need to make copy for posting unless you want to change something, such as delete data.

[DariusD]

stemproject.zip

Ok I have an order form in this database... same project.. same problem.. Hope you can help soon..