Macro for splitting a field?

[Izod]

I'm new, hope I describe my dilemma ok. I've got a large DB from the
County. They have
the "house Number" in the same field as the Street Name. It is always
the 1st 4 characters followed
by a space. I need to grab the House number and put it in it's own
field as well as removing it from
it's existing field. What software that works with DB allows me to do
that? Any help appreciated.

--
Tks Izod

[Bob Quintal]

"Izod" <No************ **@tampabay.rr. com.invalidwrot e in
news:45******** **************@ roadrunner.com:

I'm new, hope I describe my dilemma ok. I've got a large DB
from the County. They have
the "house Number" in the same field as the Street Name. It
is always the 1st 4 characters followed
by a space. I need to grab the House number and put it in
it's own field as well as removing it from
it's existing field. What software that works with DB allows
me to do that? Any help appreciated.

First of all, why? the house number is part of the address, and
should stay there.

If you need just the street, for sorting, for example, just
create a query that contains the calculated field

Street: mid([table name].[address],6)

and use the query instead of the table in your forms and reports
If you do have a valid reason for getting the house number, use

HouseNum: mid([table name].[address],1,5)

You don't need no stinking macro. :-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Izod]

Hey.... Thanks a ton, You guys have helped me immensely...... .

IZOD

"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .

"Izod" <No************ **@tampabay.rr. com.invalidwrot e in
news:45******** **************@ roadrunner.com:

>I'm new, hope I describe my dilemma ok. I've got a large DB
from the County. They have
the "house Number" in the same field as the Street Name. It
is always the 1st 4 characters followed
by a space. I need to grab the House number and put it in
it's own field as well as removing it from
it's existing field. What software that works with DB allows
me to do that? Any help appreciated.

First of all, why? the house number is part of the address, and
should stay there.

If you need just the street, for sorting, for example, just
create a query that contains the calculated field

Street: mid([table name].[address],6)

and use the query instead of the table in your forms and reports
If you do have a valid reason for getting the house number, use

HouseNum: mid([table name].[address],1,5)

You don't need no stinking macro. :-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com