Sorting by last name with multiple records

  • Thread starter Thread starter mcdonal3
  • Start date Start date
M

mcdonal3

I am trying to create a report that sorts by last name. Each individual has
multiple addresses. Currently I have the names in the ID header section.
The report is showing the records for multiple people with the same last name
(it was not when I had the name in a "Last Name" header section), but it is
creating separate name headings for the main office and the other offices.
How can I get it to list all offices under the same name?
 
I'm not sure I'm visualizing how you have your report defined...

If you want all addresses belonging to the same individual, you'd need to
group by individual and show address info in the Details section.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
When I sort by name it does not include the names of multiple people with the
same last name. I need the report to sort by name and include all of the
office addresses with the name. I can get it to do one or the other, but not
both.
 
?Sort by LastName,
Sort by FirstName, in that order.

That doesn't give you what you want?

Another possible approach would be to use a query to feed that report, and
in the query, concatenate LastName & ", " & FirstName, then sort in the
report on that concatenated FullName.

Or if your persons have PersonIDs, group by PersonID and show the LastName
and FirstName fields.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top