A Report Omits a Common Name of Two different Records

[Andrew]

Hi,

I am working on a simple Access DB that tracks students, classes, etc. So
far so good. I am creating a report (using Wizard) which lists each student's
last and first name, followed by a list of 2 to 5 classes that they are
enrolled in. So far so good.

The report looks great except for one small issue. In the case of students
who share a common last name (e.g. we have a John Smith and a Sara Smith -
and records are sorted by last name and then by first name), the second
student's name is completely missing and it seems (to the viewer of the
report) almost as if the first student (eg. John Smith) is enrolled in Sara's
classes. This occurs again with two "Allens" and two "Woods". No matter what,
if two students share a last name, the second student's name is missing.

Does anyone know why this is happening and what I can do to solve it?

Thanks for your time!

 

[Arvin Meyer [MVP]]

Group on the StudentID instead of the last name, and put the last name and
first name field controls in the StudentID group header. Make sure Hide
Duplicates is set to No for the last name field textbox.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Douglas J. Steele]

Note that if you still want the report sorted alphabetically by last name
and first name, you can have all 3 fields in the Sorting and Grouping dialog
(making sure they're in last name, first name and student id order) so that
they're sorted as desired, but only have grouping on the student id field.

While you might be tempted to only have last name and first name in the
Sorting and Grouping dialog, and group on first name rather than last name,
that will lead to problems when you have two students with the same first
and last names.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[schasteen]

It sounds like a sorting and grouping issue. You want to group by your
primary keyand then sort by the last name. It sounds like you have it
grouped by the last name.