How would you use a query to update a specific record in a table?</SPAN>
For example, a query (called “qryUpdate01”) runs with some built in filters and displays all of the remaining records as a datasheet.</SPAN>
Example:</SPAN>
qryUpdate01</SPAN>
<TBODY>
</TBODY>
I want to take these results and insert the “ApptComment” field into another table in the “Appt01” Field where the following fields match SSN (destination table) and tblSchedSSN (query)</SPAN>
tblTempCalendar</SPAN>
<TBODY>
</TBODY>
For example, a query (called “qryUpdate01”) runs with some built in filters and displays all of the remaining records as a datasheet.</SPAN>
Example:</SPAN>
qryUpdate01</SPAN>
ApptComment</SPAN> | tblSchedSSN</SPAN> |
Chop down cherry tree</SPAN> | 000-00-0001</SPAN> |
Muffle Parrot</SPAN> | 000-00-0008</SPAN> |
<TBODY>
</TBODY>
I want to take these results and insert the “ApptComment” field into another table in the “Appt01” Field where the following fields match SSN (destination table) and tblSchedSSN (query)</SPAN>
tblTempCalendar</SPAN>
Name</SPAN> | SSN</SPAN> | Appt01</SPAN> | Appt02</SPAN> | Appt03</SPAN> | …Appt31</SPAN> |
Washington, George</SPAN> | 000-00-0001</SPAN> | Chop down cherry tree</SPAN> | | | |
Adams, John</SPAN> | 000-00-0002</SPAN> | | | | |
Jackson, Andrew</SPAN> | 000-00-0008</SPAN> | Muffle Parrot</SPAN> | | | |
<TBODY>
</TBODY>