Hello all, I am trying to do 2 things with my query. 1st is my select query, where i put in a date of what i want to update (records with date_recd=03/29/2010, date_emailed=null) then I click my update query (update with date emailed=03/29/2010,userid_emailed=environ"username").
My problem is that it doesnt allow me to save my update criteria and my select criteria in the same query. When i save in select query it blanks out my update criteria of environ"username".
Is there a better way to do what im trying to acheive? Im trying to come up with ideas.. but nothing yet. Thanks..Chris