Solved

Acess Vlookup equivalent without using VBA

Posted on 2009-07-01
1
315 Views
Last Modified: 2012-05-07
Hi,

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.
0
Comment
Question by:Shino_skay
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 24754677
DLookup() is probably the closest

Dlookup("fieldname", "tablename", "IDFieldname= " & somenumber)
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now