query to sort surnames

[Bob M]

Hi


This request is for an 85 year old genealogist friend
She transcribes local cemeteries and uses access 2003

She wishes to sort the surnames as follows..............
.......
LYONS
Mac+ whatever
MACALISTER
MACEDO
MACK
MACKLE
..........

i.e. she wishes to have all the Mac names appearing before the rest of the MA... names
H
Any suggestions on how to achieve this using a query?

Thank you

Bob M

[ranman256]

make 3 queries then put them all into a UNION quiery
Q1 , sort by A-L, .....where left([last],1)<"M"
Q2 , grab only MAC .....where [LAST] like "MAC*"
Q3 , sort by M-Z, .....where left([last],1)>"L" and ([LAST] NOT like "MAC*")

put them all together in the union query
select * from Q1
union
select * from Q2
union
select * from Q3

then just run the union query.

[Bob M]

Thank you very much.....

Bob M