What about creating two fields: one for house numbers, and one for street
names. Then you can do three sorts in your query.
Al
----- Original Message -----
From: "Ian Carmichael" <[log in to unmask]>
> I recently started receiving work-orders via spreadsheet. Data consists
of
> acct. numbers, names, addresses and phone info. I need info first sorted
by
> zipcode then by address. It is in the addressing fields that I'm having
> problems.
>
> For example, say I have the following addresses
>
> 10 E. 101 st
> 40 Garrett St
> 123 Main St
> 100 E. 105 St
> 3005 E. 83 St
> 111 Willis St
> 1400 Smith St
> 3005 E. 83 St
>
> After a sort, I end up with the following order:
>
> 10 E. 101 st
> 100 E. 105 St
> 1001 E. 103 St
> 111 Willis St
> 123 Main St
> 1400 Smith St
> 3005 E. 83 St
> 40 Garrett St.
>
> I need to keep the "E."(East) street addresses in contiguous order, but
> can't seem to do so. I realize it's sorting on the house numbers. Is
> there any way of sorting the way I want it without re-editing multiple
> pages of document(s). Any help greatly appreciated. TIA
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|