 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2008Sorting by last name with multiple records
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 >I am trying to create a report that sorts by last name. Each individual >has [quoted text clipped - 5 lines] > 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? 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. > I'm not sure I'm visualizing how you have your report defined... > [quoted text clipped - 15 lines] > > 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? ?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 > When I sort by name it does not include the names of multiple people with > the [quoted text clipped - 26 lines] >> > offices. >> > How can I get it to list all offices under the same name? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.