aka OASys1" id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4603080" /existing records? I posted a reply a couple of days ago but I just noticed it didn't appear. When response come via info path form in Outlook email they automatically update the table. or write a macro that contains what OASys1 included in his sql that you can set to run during the "Collect and Update Data via E-mail" ? The users are selecting their top 5 course preferences.
Tip: Back up your database before you run an update query.
Question #1: I have a table where I have two date fields.
"First_Session_Used" and "Scheduled_Review_Date" are the two fields.
Here are the similarities and differences between Find and Replace and an update query: Like the Find and Replace dialog box, an update query lets you specify which value is being replaced, and what the new value is.
Unlike the Find and Replace dialog box, an update query lets you: As a best practice when creating an update query, first create a select query that identifies the records that you want to update, and then convert that query to an update query that you can run to update the records. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions.