G
Guest
My table has a field called [City]. Data in this field has a City Name and a
State designator.
IE Boston, MA
I have created a new field in the table named [State]
I would like to insert the state deisgnator into the new field and then
delete everything after the comma in the field [City]
I would imagine that this should be a 2 step process
1st process
Move the state designator over (it appears that there is a null between the
, and the state designator MA) I need help with the syntax to accomplish
this.
If the 1st process works OK.
2nd process
Remove all characters after the , in the field [City]
Again I could use help with the syntax to get this accomplished.
(I would imagine this would be an update query but not positive)
Will I have to run a 3rd process to remove the nulls that may be inserted
into the State field when I run the 1st process? If so then I would imagine
that you already know that I would need help with that syntax also.
Thanks in advance for any insight.
State designator.
IE Boston, MA
I have created a new field in the table named [State]
I would like to insert the state deisgnator into the new field and then
delete everything after the comma in the field [City]
I would imagine that this should be a 2 step process
1st process
Move the state designator over (it appears that there is a null between the
, and the state designator MA) I need help with the syntax to accomplish
this.
If the 1st process works OK.
2nd process
Remove all characters after the , in the field [City]
Again I could use help with the syntax to get this accomplished.
(I would imagine this would be an update query but not positive)
Will I have to run a 3rd process to remove the nulls that may be inserted
into the State field when I run the 1st process? If so then I would imagine
that you already know that I would need help with that syntax also.
Thanks in advance for any insight.