K
kb
I have a table with one address field of street address, city, state and zip
and need to split them into 4 fields. Is there sql I can use in an update
query to do this? I used one to split the name field into two fields --
Left([fullname], InStr([fullname], " ") - 1) and Mid([fullname],
InStr([fullname], " ") + 1) -- but can't quite figure out how to edit this
for the address. There are commas after the street address and city value.
Access 2007. Thank you so much!! kb
and need to split them into 4 fields. Is there sql I can use in an update
query to do this? I used one to split the name field into two fields --
Left([fullname], InStr([fullname], " ") - 1) and Mid([fullname],
InStr([fullname], " ") + 1) -- but can't quite figure out how to edit this
for the address. There are commas after the street address and city value.
Access 2007. Thank you so much!! kb