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

Can I extract a street address using a query?

P: n/a
Does anyone know how to create a query that will separate the street number
from the street name?

Eg.
current address field = 14 Main Street, unit 4

but I want to get:
streetno = 14
streetname = Main Street

--
Regards,
Peter

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Peter,

Look at the Instr function and Left function to get the street number. Use the
Instr function to find the position of the first space and the Left function to
return everything before the first space.

To get the street name, use the Instr function to see if there is comma in the
address and use the Mid function with the first Instr function to get the street
name.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"wolftor" <wo*****@rogers.com> wrote in message
news:hr*******************@twister01.bloor.is.net. cable.rogers.com...
Does anyone know how to create a query that will separate the street number
from the street name?

Eg.
current address field = 14 Main Street, unit 4

but I want to get:
streetno = 14
streetname = Main Street

--
Regards,
Peter

Nov 12 '05 #2

P: n/a
Can anyone help?

"wolftor" <wo*****@rogers.com> wrote in message
news:hr*******************@twister01.bloor.is.net. cable.rogers.com...
Does anyone know how to create a query that will separate the street number
from the street name?

Eg.
current address field = 14 Main Street, unit 4

but I want to get:
streetno = 14
streetname = Main Street

--
Regards,
Peter


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.