Sorting and Grouping Question

[Kathy]

I'm sure this is simple, but can't think how to do this. I have a report
that prints out a contact list with addresses, etc. There are multiple
records (people) with the same last name, but they are in fact different
contacts. When I group by last name, the report of course puts the detail
information for the all the records with the same last name together, rather
than as separate contacts. When I group on the ID field is separates each
record nicely, but the sorts by ID and not by last name. How can I group
them by ID, but sort them by Last Name? In the sorting box, there isn't an
option to select "none" in the sorting column of ID.

Thanks in advance. Kathy

 

[fredg]

I'm sure this is simple, but can't think how to do this. I have a report
that prints out a contact list with addresses, etc. There are multiple
records (people) with the same last name, but they are in fact different
contacts. When I group by last name, the report of course puts the detail
information for the all the records with the same last name together, rather
than as separate contacts. When I group on the ID field is separates each
record nicely, but the sorts by ID and not by last name. How can I group
them by ID, but sort them by Last Name? In the sorting box, there isn't an
option to select "none" in the sorting column of ID.

Thanks in advance. Kathy

In the Report's Sorting and Grouping dialog, set the NameField above
the ID field.
NameField Ascending (Group Header No)
IDField Ascending (Group Header Yes)

The A's will appear before the B's but the data in the group will be
according to ID.

 

[Kathy]

Voila! I knew it would be simple. I thought I'd tried every combination of
grouping and sorting. THis worked beautifully. Thanks!