I have created a custom report, however, I can't seem to get it to sort by street properly. In the pre-packaged report when you select sort by street address, it keeps all streets grouped together (1 Any Street, 2 Any Street, etc), however, when I select the sort field to be address1, I get the following: 1 Any Street, 1 Beta Street, 1 Charlie Street, etc.
Any thoughts? I know there is an easy solution
Sorting Query By Address
Moderators: Moderators, Tech Support
Re: Sorting Query By Address
I think you have to parse past the numbers as the system will sort on the first set to characters, thus you get the 1 Smith, 10 First St, 120 Second ... and so on first.R.V.Fagan wrote:I have created a custom report, however, I can't seem to get it to sort by street properly. In the pre-packaged report when you select sort by street address, it keeps all streets grouped together (1 Any Street, 2 Any Street, etc), however, when I select the sort field to be address1, I get the following: 1 Any Street, 1 Beta Street, 1 Charlie Street, etc.
Any thoughts? I know there is an easy solution
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.