Grouping

[rsche]

I've created a report listing last name, first name, location, city, and page number. I grouped them alphabetically in the query and the sorting and grouping box. My problem is when I put in (Group Header) =Left ([LastName],1) to print the first letter of the group such as A for the last names beginning with A I lose the alphabetizing of the last names, all the A's are together but they are not in order. What am I doing wrong?????

 

[cpod]

You have to enter the LastName field twice in the Grouping/Sorting dialog box. Once with a group header - sorted ascending. And once for just sorting.

 

[rsche]

It worked! Thanks so much.