Messed up Sort

[bbulla]

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??

 

[HiTechCoach]

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??

Sorting it best done in the report, not the query. Once you start using grouping, this overrides any sorting in the query.

You will need to add additional sorting to the report.

 

[bbulla]

Hi Boyd,

Thanks for your help. Didn't totally solve the problem though. I did change the report to source from just the table, but what actually solved it was to add two sorting levels:

1. StreetName; GroupOn 1st Character; Ascending
2. StreetName; GroupOn Entire Field; Ascending

Now I have all the A's, B's, etc. on a new page, sorted alphabetically.

Thanks

 

[HiTechCoach]

Hi Boyd,

Thanks for your help. Didn't totally solve the problem though. I did change the report to source from just the table, but what actually solved it was to add two sorting levels:

1. StreetName; GroupOn 1st Character; Ascending
2. StreetName; GroupOn Entire Field; Ascending

Now I have all the A's, B's, etc. on a new page, sorted alphabetically.

Thanks

That was exactly what I thought you would need to do, thus the previous suggestion of add additional sorting.

Glad you got it working!