Access query lookup calculated field in table

BarbaraT

New Member
Joined
Nov 2, 2003
Messages
45
I want to have a query calculate a field (and ID) and then lookup that ID in a table to turn it into clear text.

Say I have two tables - one with Clients and the Employee Rep associated with them, and the 2nd with employee IDs and names. But, the workload is reorganizing, and so some clients will be assigned new employee representatives. I want to use a query to generate those new client/employee relationships.

The ID of the new Employee Rep is calculated in the query (changing B to A) and then I want to lookup the new ID in the employee ID table to get the new name. How do I do that lookup within a query?

Picture1.png
 
Hi, bit late to the party, but you couldn't you just add the tables to the query without a join and then put your calculated ID in the criteria of the Employee ID field. Something like..

1741018914037.png
 
Upvote 0
Nice solution. However, I think I'd add Not Like "*A" so that you don't get records with 123A | 123A | Fred.
I took it that what was wanted was to change the name associated with the client, which is why I said to use update query. Perhaps that was not what was wanted.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top