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