<

MS Access – Using DLookup

Posted on
8,139 Points
1,839 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
7:24
Jim Dettman (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
0 Comments

Featured Post

Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Generating random numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more work. Here we will show how to accomplish this with a few lines of code.
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month