Hi,
I am creating a report based on a query that sorts my data (street names) alphabetically. As I want to start each new starting letter on a new page I am using the 'Sorting and Grouping' to specify:
StreetName: Ascending
GroupHeader: Yes
GroupFooter: No
GourpOn: Prefix Characters
GroupInterval: 1
KeepTogether: No (not sure what this does??)
Once I do this, I get all the StreetNames on separate pages, but now the sorting that is done in the query is all messed up. The 'A's are together, but they are no longer alphabetical.
Any ideas??
I am creating a report based on a query that sorts my data (street names) alphabetically. As I want to start each new starting letter on a new page I am using the 'Sorting and Grouping' to specify:
StreetName: Ascending
GroupHeader: Yes
GroupFooter: No
GourpOn: Prefix Characters
GroupInterval: 1
KeepTogether: No (not sure what this does??)
Once I do this, I get all the StreetNames on separate pages, but now the sorting that is done in the query is all messed up. The 'A's are together, but they are no longer alphabetical.
Any ideas??