Dlookup Function

[Suresh Jain]

Please give me an example of Dlookup in MsAccess & let me know how it works. Thanks

[Lysander]

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?

[vkong85]

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.