A Report Omits a Common Name of Two different Records

A

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!
 
D

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!)
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top