Can I extract a street address using a query?

[wolftor]

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

[PC Datasheet]

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

[wolftor]

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