Mass Update Query

M

Mr Bo Jangles

How do you copy the values in one field into another field? (Thousands of
records). I do not know how to write code and not much good at SQL. Really
need to use the user tools built into Access. I need something like: copy
values from 'Effective Date' to 'Hire Date'. I need to do this in order to
change the format without losing data. This is data imported from Excel and
originally imported into Excel from AS400 GUI. I hope I have given enough
info...
 
R

Rosco

What you want to do is create an Update query.
In the query builder, add the table.
Under the query menu, select update query

In the grid drag the field you want to update ( the destination)
In the update row- type the following: [table name]![source field name]
substituting your actual table and field names.

I would make a copy of your table and practice on that first.

Hope this helps
Rosco
 
A

Andi Mayer

On Thu, 9 Dec 2004 08:53:01 -0800, "Mr Bo Jangles" <Mr Bo
How do you copy the values in one field into another field? (Thousands of
records). I do not know how to write code and not much good at SQL. Really
need to use the user tools built into Access. I need something like: copy
values from 'Effective Date' to 'Hire Date'. I need to do this in order to
change the format without losing data. This is data imported from Excel and
originally imported into Excel from AS400 GUI. I hope I have given enough
info...
Click to expand...


Update theTable SET [Hire Date]=CDate([Effective Date])

past this into the query tool in the SQL, but change theTable to the
right table and the fields to right fieldsnames.

Best you try it first with a copy

i have asumed that [Hire Date] has date format and effective has
string format

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Top