Could you post to this thread the releavnt table layouts
indicating the location of the source data and the
destination columns.

Gerald Stanley MCSD
-----Original Message-----
Does anyone know of a way of copying data in 1 field in a
row to other multiple blank fields in a large table?

I have filtered records and want to copy a particular bit
of data to thousands of rows, where this field is
presently blank.

I have tried everything to no avail. Have looked at Access
help and spoken to the Office IT 'guru'. Have tried using
the mouse, keyboard and also 'find and replace'.

I know I could export the table into excel, copy this info
easily and then import back into the Access DB. However as
I have to do this exercise for numerous DBs I would rather
not.

There has to be a way surely?

Frustrated and Fed Up!

Frustrated
.