J johnb23 Registered User. Local time Yesterday, 16:37 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 Yesterday, 18:37 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.
