Copying Data from 1 field to multiple fields?

  • Thread starter Thread starter Ruth Whitelaw
  • Start date Start date
R

Ruth Whitelaw

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
 
Could you post to this thread the releavnt table layouts
indicating the location of the source data and the
destination columns.

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

UPDATE MyTable
SET MyField = "Something"
WHERE MyField IS NULL


Hope that helps


Tim F
 
Back
Top