<

Watch MS Access – Using DLookup

Posted on
8,171 Points
1,871 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
Many applications need to compute the road distance between two addresses.  Numerous websites perform this function, but to build this feature into your application, you must use an API to call these features via the internet.  This article discusse…
Subforms can still help us achieve what we want to achieve as long as we understand how to use the MS Access tools.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month