By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Dlookup Function

P: 1
Please give me an example of Dlookup in MsAccess & let me know how it works. Thanks
Jul 19 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 344
Please give me an example of Dlookup in MsAccess & let me know how it works. Thanks
Access Help DLookup gives loads of information about this function. What more information do you need?
Jul 19 '07 #2

P: 24
dlookup ( "[field that you need]","[table that the field is located]","any criteria you may have")

ex:

dlookup ("[name]","[tbl people]"," ID = [tbl people][id]")

so in the example above you are looking for a name in the people tbl so long as the id's match.
Jul 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.