Acess Vlookup equivalent without using VBA


Is there a vlookup equivalent in Access? I ran a query and would like to use the results as a driver to pull information out of a specific field from another table. I seen some VBA solutions but I want to avoid that for now. Any help would be appreciated. Thanks.
Who is Participating?
peter57rConnect With a Mentor Commented:
DLookup() is probably the closest

Dlookup("fieldname", "tablename", "IDFieldname= " & somenumber)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.