Order by first 2 digits

ninja_imp

Registered User.
Local time
Today, 12:39
Joined
Apr 11, 2006
Messages
50
Hi

I have a report that list all customers. My only problem is that it only orders them by the first number of their address because it has the street name as well. Eg:

1 Bedford Street
22 Bedford Street
3 Bedford Street

and so on.

I did have the the number and street address in seperate fields and that ordered by number but it didnt keep the streets in sequence which is also important.

Does anyone have any idea how i could get this to work.

Regards

Simon
 
What if the address have 3 digits or more, like 1234 Main Street? Also, that same address would fall in the middle of your Bedfords in your current scheme.

You were better off with the numbers in a separate field, then put your primary sort on the street name with a secondary sort on the street number field.
 
hi

tried that but:

If the addresses were

12 bedford

13 bedford

7 beresford


It would put the beresford address in the middle of the 2 which isn't right.

Is there any other to make it order on exact match or something

cheers for your help
 
If the numbers and names were in separate fields, and the primary sort was on name, there's no way it would put anything between the 2 Bedfords.
 
ok mate - ill give it a go and let you know how i get on
 

Users who are viewing this thread

Back
Top Bottom