How do I change an inherited 1 field address into a 3 field addre.

[Guest]

How do I change an inherited 1 field address into a 3 field address. For
example, how do I change the one field address 1031 N. Maple into a three
field address:
field 1: 1031 field 2: N field 3: Maple.

Thank you

 

[Arvin Meyer]

You can parse it out in a query, 1 field at a time using the Left(),
Right(), and MID() functions. In many cases, that might be a good thing to
do. It is with names and with City, State, Zip. But it is not usually the
case for an address field since 1031 N. Maple describes exactly 1 attribute,
and isn't normally decomposible.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access