I
Izod
I have in the past (longtime ago) corrected data in a field using a macro or
query. For example; I got to the 5th position in the field, then copied
the next four positions, then placed them in a new field. A good example
is; getting the house number only from an address that had house number and
street name.
5555 Washington St cut the 5555 and put it into a new field set up for str
number.
Can someone tell me where to start looking, I have a dozen access books but
can't seem to find the answer.
Thanks for any help
Izod
query. For example; I got to the 5th position in the field, then copied
the next four positions, then placed them in a new field. A good example
is; getting the house number only from an address that had house number and
street name.
5555 Washington St cut the 5555 and put it into a new field set up for str
number.
Can someone tell me where to start looking, I have a dozen access books but
can't seem to find the answer.
Thanks for any help
Izod