split expression

[ace1234]

I have an address field such as "222 Avonhead Road".

I wish to make a query? to sort on the road name ie "Avonhead" and list all entries in alphabetical order.

is this possible??

ace1234

[MMcCarthy]

Create a new query

SELECT Mid([AddressField], InStr([AddressField]," ")+1) As Street
FROM TableName
ORDER BY Street;

This query will find the first space on the address line and create a new field starting with the next character.

I have an address field such as "222 Avonhead Road".

I wish to make a query? to sort on the road name ie "Avonhead" and list all entries in alphabetical order.

is this possible??

ace1234