Big Error

[PA]

An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.

 

[John W. Vinson]

An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.

If you are certain that *every* occurance of YED-14- should be removed, run an
Update query updating this field:

UPDATE yourtable
SET thisfield = Mid([thisfield], 8)
WHERE thisfield LIKE "YED-14-*";

Make a fresh backup first just in case!!

 

[Duane Hookom]

You can also open the table in datasheet view and place the cursor in the
soiled field. Use find and replace from the edit menu. Select to find the
value anywhere in the field.
--
Duane Hookom
Microsoft Access MVP

An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.

Is there a way to remove the YED-14- without doing it manually or
requesting IT to restore the database from backups, and return the values to
there original values.

This will really save us embarrasement.
Thank you ever-so-much.

If you are certain that *every* occurance of YED-14- should be removed, run an
Update query updating this field:

UPDATE yourtable
SET thisfield = Mid([thisfield], 8)
WHERE thisfield LIKE "YED-14-*";

Make a fresh backup first just in case!!