<

MS Access – Using DLookup

Posted on
7,707 Points
1,410 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
7:24
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.

Video Steps

1. Specify the first argument, which is the expression to be returned

2. Specify the second argument, which is the data source. This may be a table or query

3. Specify the third argument, which is the criteria

4. How to return multiple fields from a single DLookup()

5. Pitfalls to avoid

3
Comment
0 Comments

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Suggested Courses
Course of the Month6 days, 17 hours left to enroll

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month