<div>
Didn't receive responses back on the question, so I was able to develop my own solution.
</div>


<div>
<div class="content wysiwyg-content">
Hey all,<br />
<br />
I have a table (Over_Ride_Chain) that has three columns: &nbsp;Chain, Old_Dept, and New_Dept. &nbsp;<br />
<br />
The chain field is lined to the chain in another table called BILMAC_CHNMSTR and they a column from that table called SSSTOR is then liked to MBSTOR in another table labeled MBRMSTR_Specs.<br />
<br />
I'm trying to create an update query for when the Chain matches the Chain/Store from MBRMSTR_Specs it will update the MBDEPT in the MBRMSTR_Specs. &nbsp;There is a problem with the logic in my criteria. &nbsp;I need the Old_Dept field in the Over_Ride_Chain table to equal the MBDEPT field in the MBRMSTR_Specs table and then to update it to the corresponding value from the Over_Ride_Chain.<br />
<br />
I know it might be confusing, so here is what the Over_Ride_Chain table looks like:<br />
<br />
Chain &nbsp; Old_Dept &nbsp; New_Dept<br />
3002 &nbsp; &nbsp;35 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
3004 &nbsp; &nbsp;35 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
<br />
and etc, there are about 7 rows of data. &nbsp;If anyone could help me with this, I'd really appreciate it.
</div>
</div>


Hey all,

I have a table (Over_Ride_Chain) that has three columns:  Chain, Old_Dept, and New_Dept.  

The chain field is lined to the chain in another table called BILMAC_CHNMSTR and they a column from that table called SSSTOR is then liked to MBSTOR in another table labeled MBRMSTR_Specs.

I'm trying to create an update query for when the Chain matches the Chain/Store from MBRMSTR_Specs it will update the MBDEPT in the MBRMSTR_Specs.  There is a problem with the logic in my criteria.  I need the Old_Dept field in the Over_Ride_Chain table to equal the MBDEPT field in the MBRMSTR_Specs table and then to update it to the corresponding value from the Over_Ride_Chain.

I know it might be confusing, so here is what the Over_Ride_Chain table looks like:

Chain   Old_Dept   New_Dept
3002    35               3
3004    35               3

and etc, there are about 7 rows of data.  If anyone could help me with this, I'd really appreciate it.

Didn&#39;t receive responses back on the question, so I was able to develop my own solution.

Problem performing update query in Access 2010

Hey all,

I have a table (Over_Ride_Chain) that has three columns:  Chain, Old_Dept, and New_Dept.  

The chain field is lined to the chain in another table called BILMAC_CHNMSTR and they a column from that table called SSSTOR is then liked to MBSTOR in another table labeled MBRMSTR_Specs.

I&#39;m trying to create an update query for when the Chain matches the Chain/Store from MBRMSTR_Specs it will update the MBDEPT in the MBRMSTR_Specs.  There is a problem with the logic in my criteria.  I need the Old_Dept field in the Over_Ride_Chain table to equal the MBDEPT field in the MBRMSTR_Specs table and then to update it to the corresponding value from the Over_Ride_Chain.

I know it might be confusing, so here is what the Over_Ride_Chain table looks like:

Chain   Old_Dept   New_Dept
3002    35               3
3004    35               3

and etc, there are about 7 rows of data.  If anyone could help me with this, I&#39;d really appreciate it.

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.