Multiple Same Records in Report

  • Thread starter Thread starter Eric C.
  • Start date Start date
E

Eric C.

Hello,

I have a report that lists the participants in a course.
These participants are teachers in our school district.
Some of the participants teach at more than one school.
When I create the report, some of these teachers are
listed on multiple lines, with the only change being the
School that they teach at.

Is there any way to group these people that teach at
multiple schools whereby only one line if data is being
printed such as name, address, etc. and on each
additional line, the school name would be printed. In
other words it would look something like this:
Teacher Name Address School
-------------------------------
Sammy Whammy 123 ABC OSU
BGU
OU

Thanks,

Eric
 
Eric

Check the Hide Duplicates property of the specific controls (e.g., text
boxes) for which you want the duplicates "hidden".

Good luck

Jeff Boyce
<Access MVP>
 
Thanks, that works great. Now is there a way I can place
a line between these duplicate records and new records?
In other words, I wouldn't want there to be a line
between two of the same teachers.

Thanks,

Eric
 
Create a group heading on the fields that could possibly duplicate and add
only these text boxes. I assume these would be to the left of all text boxes
in the detail section. Then add code to the On Format event of the group
header:
Me.MoveLayout = False
 
Back
Top