Sort Ascending Within Group

[depawl]

Hello:
I have a report that lists client's names alphabetically. I have it grouped by first letter of their last name. In other words the "a's" are grouped together, then the "b's", etc. The report is based on a query that has the names sorted alphabetically ascending. What I need is to have the names in each group also sorted ascending alphabetically, but they are not. In other words, last name "Allen" should be listed before "Ammon", but it is not. I have grouping and sorting in the report set as follows:
Group On: Prefix Characters
Group Interval: 1
Keep Together: No
Thanks for the assistance.

 

[boblarson]

Make sure you don't have another higher level group in the Grouping and Sorting. Otherwise, setting the sort to ascend for that group in the Grouping and Sorting should sort it for you (query level sorts don't come over to reports).

 

[depawl]

No, I only have the one group, sorted on Client_Name. It sorts by the first character correctly, the "a's" , "b's", etc. are sorted, but the names within each group are not. Is there a way to do another sort within each group?

 

[boblarson]

Instead of grouping on the first character first, put in a sort first and then group by the individual character like this:

 

[depawl]

Thanks Bob. That did the trick.
As always, your responses are quick and right on the money.