Action query to make a field = another field

[Autoeng]

I have two fields the have differing dates in them. I need an action query to make the date in one field the same as in the other. I have thousands of records to do this to. Is there a way via an action query (update?) to do this or does it have to be an SQL statement query?

 

[boblarson]

You should be able to use an UPDATE query and put in the date you want to update as the only field and then in the UpdateTo area in the query put [YourDateFieldHereThatYouWantTheDateFrom] (replacing the name I have here with the actual name of your date field you want the date from), making sure to use the brackets so it knows you want the field name.

 

[Autoeng]

Yes indeedy, Bob. Thanks for the help!