By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

split expression

P: 1
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
Oct 15 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Oct 15 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.