I created an update query using two tables but it isn't updating--no error msg. I need to update the date field in one table (localupdate) with the date field in another table (setup). I set the field row to local date, the table to the localupdate table and the "update to" row to [setup].[updatedate]. Other than this, is there an easier way to accomplish this from within a macro?