How can I transfer the data from a query to a table in a similar manner as Excel Vlookup?

[Mike Tosh]

Hello everyone,



I have Access 2019 and after plenty of tutorials I was still unable to solve my issue.

I barely have any experience in Access and the database that I work on has been handed to me. I was tasked to create a countdown tab and I managed to do that using DateDiff, but now I am unable to move the column (just like a Vlookup) with the results to a table that has all the information. I saw something about a function Dlookup, but it seems like I cannot use that in a table (or maybe I can but I do not know how to do it).

Could anyone help me?

Thank you!

[Homegrownandy]

what do you mean by countdown tab? you shouldn't need any lookups if data is relating to each other correctly. Explain what you are trying to achieve without what you have tried. I guess there will be better ways to get the same result.