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