Hi all,

i am trying to run an update query to replace the last two characters in a
field to no avail.
I think I am going about it wrong. I would like a few suggestions please on
how to perform this task.

I am trying with the replace function then mid$ last two characters and
trying update
I am gett erratic changes.


an example of one record/field data is as follows:

012004

and it needs to be :
01202004

Thanks in advance

Bob

Post what you've tried... we don't know what that is.

Assuming that these are the data and what the data should be:
012004 should be 01202004
011904 should be 01192004
110304 should be 11032004

etc., then an update query would look something like this:


UPDATE MyTableName
SET MyFieldName =
Left([MyFieldName], 4) & "20" &
Right([MyFieldName], 2);

--

Ken Snell
<MS ACCESS MVP>



"Bob Bevins" <bob (AT) virteck (DOT) com> wrote