We help IT Professionals succeed at work.

Access 2003:  Reports - Grouping

mytfein
mytfein used Ask the Experts™
on
Hi EE,

Can you help me with grouping on a report, please?

Just need a separator line when student's id changes.

2 rows can appear for a student:

MA - mailing address row
PR  - permanent address row

below is a test mdb

Please can you explain the steps as to how you grouped by student....

tx for your help, sandra
EE-studentMasterList-frontend.mdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The problem is with your group, sort, and total settings.  Right now you have the ID as fifth on your list of groups/sorts, move it first and I believe you get what you want.  Or at a minimum move the group on ID above the address_type.

Author

Commented:
Hi Master Jojo,

moving the id up to the first field solved the problem

in fact, i now moved the name info into the id header, so that only the address information
duplicates in the detail area...

tx again, s
Glad I could help.