Vlookup and Circular reference

[xfg85]

I have a table with the following info:

Emp ID
Mgr ID

and I want to get

Emp
Mgr ID
Mgr Mrg ID

I can do this in excel by
Emp
Mgr ID
Mrg Mrg ID - vlookup using the Mgr ID

But how do I translate this into Access?

Thanks!

 

[John Big Booty]

Welcome to the forum.

I believe the DLookup() function is what you will be looking for.

 

[accessfever]

You might want to try this in the Access Database.
a) Link the excel file in Access
b) Create an update query to update the excel file's "mgr mgr ID".
c) Pull original table A and excel file in the query
d) Link table A's "mgr.ID" with excel file's "employee ID"
e) Update excel A's "mgr.mgr. ID" with table A's "mgr. ID" if the link in (d) is not null.