<div>
Use the query designer. Start with creating a SELECT query which returns the data necessary to do this. Then change the query to UPDATE and set the Update To columns and their source column.
</div>


Use the query designer. Start with creating a SELECT query which returns the data necessary to do this. Then change the query to UPDATE and set the Update To columns and their source column.

mlcktmguy

<div>
Could you post some sample pertinent data for the two tables (in text, not pictures), please, and what you expect as a result of the update of that data?
</div>


Could you post some sample pertinent data for the two tables (in text, not pictures), please, and what you expect as a result of the update of that data?

<div>
<div class="content wysiwyg-content">
I want to update values in one table 'tblTaxRecs' with information from another table 'tblFees'<br />
<br />
tblFees contains two fields 'BRT &nbsp;Numeric Long Interger' and &nbsp;'FeeAmount &nbsp; Numeric Double'<br />
<br />
The Pertinent fields in tblTaxRecs' are 'BRT numeric Long Integer', 'TaxYear &nbsp;Numeric Long Interger', 'FeeAmount &nbsp;Numeric Double', 'DateRevised Date', 'UserRevised Short TExt'.<br />
<br />
For every record in tblTaxRecs with a taxyear of 2018 and matching a BRT in tblFees, I want to replace the 'FeeAmount' with the corresponding FeeAmount in tblFees that matches the BRT in tblTaxRecs. &nbsp;If possible I also want to stamp each updated record in tblTaxRecs with the current date and time in field 'DateRevised' and the string 'Updt20190318'.
</div>
</div>


I want to update values in one table 'tblTaxRecs' with information from another table 'tblFees'

tblFees contains two fields 'BRT  Numeric Long Interger' and  'FeeAmount   Numeric Double'

The Pertinent fields in tblTaxRecs' are 'BRT numeric Long Integer', 'TaxYear  Numeric Long Interger', 'FeeAmount  Numeric Double', 'DateRevised Date', 'UserRevised Short TExt'.

For every record in tblTaxRecs with a taxyear of 2018 and matching a BRT in tblFees, I want to replace the 'FeeAmount' with the corresponding FeeAmount in tblFees that matches the BRT in tblTaxRecs.  If possible I also want to stamp each updated record in tblTaxRecs with the current date and time in field 'DateRevised' and the string 'Updt20190318'.

Query Help

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.