Sorting Query By Address

[R.V.Fagan]

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

[NeilZ]

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

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.