vlookup into table from query

[araza123]

Hi guys,

the title kinda describes what is need. Is is possible to do this? I have a query I ran with data. Theres a field called "LTV". I need to replace the data from this field to a table I have created. the table also has a LTV field. I have a common unique identifier to do the lookup on if this was excel but not sure if its possible in access. Thanks for your help

 

[CJ_London]

DLookup is the equivalent to Excel's VLookup

Something like this in a query

luLTVlookup("LTV","OtherTable","UniqueID=" & [UniqueID])

replace field and table names as required

 

[Gasman]

Join the tables using your unique identifier?

 

[plog]

Dlookups have no place in queries.

Instead you use SQL and JOIN any datasources you need. In design view, bring in whatever table has your LTV field, JOIN it to whatever existing datasource it should go to using the field that connects them, then bring down the LTV field into the query below to show it.

Here's a great source for learning about SQL:

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com