Hi All,
I have following fields in access table
First Name, Laste Name, DOB. Content, SchoolName, Address, City, State and Zip.
The content is same for all reports, but each school will have 1 to many student.
The report should look like this
School Name
Address
City
State
Zip
Content
First Name|Last Name|DOB
The problem is if the School has more than one student then each student will get a different letter
But what we want is if the School has multiple students, then their names and DOB should be in one letter only.
I tried to use grouping on SchoolName, Address and all, but it is not working. Any other tips and ideas will be very helpful
Thank You