J johnb23 Registered User. Local time Today, 09:02 Joined Mar 23, 2005 Messages 14 Feb 10, 2006 #1 I need to sort an address field by street name only. The address info is stored as: 123 Main Street, etc. Is there a way to omit the number portion of the field during a sort function in Design View?
I need to sort an address field by street name only. The address info is stored as: 123 Main Street, etc. Is there a way to omit the number portion of the field during a sort function in Design View?
L llkhoutx Registered User. Local time Today, 11:02 Joined Feb 26, 2001 Messages 4,018 Feb 10, 2006 #2 You have to parse the street. Use of addresses require a lot of thought. There's no simple answer because addresses come in all kinds of forms.
You have to parse the street. Use of addresses require a lot of thought. There's no simple answer because addresses come in all kinds of forms.
