Report not filtering

  • Thread starter Thread starter ravynfaire via AccessMonster.com
  • Start date Start date
R

ravynfaire via AccessMonster.com

Hello. I need to have a report I have designed keep names together. What I
mean by that is below.

Under detail, I have a field for Manager's names and when I click on print
preview it has a line for each manager for entry in the database.


Manager: Megan Santiago
Tran, Thomas 512 W. 1st, Nowhere, CA

Manager: John Smith
Luis, Tom 514 W. 11th, Nowhere, CA

Manager: Megan Santiago
Bryan, Holly 2157 E. 9th, Nowhere, CA


I need to have it so that it looks like this:

Manager: Megan Santiago
Tran, Thomas 512 W. 1st, Nowhere, CA
Bryan, Holly 2157 E. 9th, Nowhere, CA

Manager: John Smith
Luis, Tom 514 W. 11th, Nowhere, CA

How do I do that?
 
Hello. I need to have a report I have designed keep names together. What I
mean by that is below.

Under detail, I have a field for Manager's names and when I click on print
preview it has a line for each manager for entry in the database.

Manager: Megan Santiago
Tran, Thomas 512 W. 1st, Nowhere, CA

Manager: John Smith
Luis, Tom 514 W. 11th, Nowhere, CA

Manager: Megan Santiago
Bryan, Holly 2157 E. 9th, Nowhere, CA

I need to have it so that it looks like this:

Manager: Megan Santiago
Tran, Thomas 512 W. 1st, Nowhere, CA
Bryan, Holly 2157 E. 9th, Nowhere, CA

Manager: John Smith
Luis, Tom 514 W. 11th, Nowhere, CA

How do I do that?
Click to expand...

Open the Report in design view.
Click on View + Sorting and grouping.

In the Field/Expression column enter the [manager] field.

In the lower panel, set the Group Header to Yes.

Save the changes.

Add the [Manager] field to the Group Header.
Place the [Employee] (Tran, Bryan, Luis, etc.) field in the Detail
Section.
 
Back
Top