<div>
the SET statement belongs to the UPDATE instruction <br />
and it's used to <b>modify existing values</b> in a table <b>with the values indicated</b> by the <i>fields located after the SET</i> keyword, for all the rows that match the logical condition in the WHERE section.<br />
<br />
Here you have <a href="http://msdn.microsoft.com/en-us/library/office/bb221186%28v=office.12%29.aspx" rel="ugc">the official Microsoft explanation</a>.
</div>


the SET statement belongs to the UPDATE instruction
and it's used to modify existing values in a table with the values indicated by the fields located after the SET keyword, for all the rows that match the logical condition in the WHERE section.

Here you have the official Microsoft explanation [http://msdn.microsoft.com/en-us/library/office/bb221186%28v=office.12%29.aspx].

<div>
In your case, the update statement changes the values in two columns (<i>[1-5 items]</i> and <i>[1-5 $]</i>) of the <i>tblOpenItemsAged </i>table.<br />
Those columns will get the values located in the fields [items] and [$] of each row having <b>AgeRange</b> = <b>&quot;1-5&quot;</b>.
</div>


In your case, the update statement changes the values in two columns ([1-5 items] and [1-5 $]) of the tblOpenItemsAged table.
Those columns will get the values located in the fields [items] and [$] of each row having AgeRange = "1-5".

<div>
<div class="content wysiwyg-content">
I am maintaining an Access 2003 application and I came across the following query<br />
<br />
UPDATE tblOpenItemsAged INNER JOIN tblOpenItemsAgeRange ON (tblOpenItemsAged.[Bank Code] = tblOpenItemsAgeRange.Bank)<wbr /> AND (tblOpenItemsAged.T = tblOpenItemsAgeRange.T) SET tblOpenItemsAged.[1-5 Items] = [items], tblOpenItemsAged.[1-5 $] = [$]<br />
WHERE (((tblOpenItemsAgeRange.Ag<wbr />eRange)=&quot;1<wbr />-5&quot;));<br />
<br />
What does the SET statement mean if you break it down?
</div>
</div>


I am maintaining an Access 2003 application and I came across the following query

UPDATE tblOpenItemsAged INNER JOIN tblOpenItemsAgeRange ON (tblOpenItemsAged.[Bank Code] = tblOpenItemsAgeRange.Bank) AND (tblOpenItemsAged.T = tblOpenItemsAgeRange.T) SET tblOpenItemsAged.[1-5 Items] = [items], tblOpenItemsAged.[1-5 $] = [$]
WHERE (((tblOpenItemsAgeRange.AgeRange)="1-5"));

What does the SET statement mean if you break it down?

How to interpret the meaning of a SET statement in a query within an Access 2003 application?

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.