DLookup Function, statement in access

Hello friends , In this video tutorial I am going to show you that you can learn DLookup function statement in access.This is special function called DLOOKUP short for Domain Lookup , which lets you look up a value in a table or query for example showing you look up the Address, Contact and Email fields from StudentT table where the StudentID is the same as the StudentID on AdmissionT form  or in this case , the value in Student Combo box  since you are picking from a list.
Dlookup statement syntax-

equal  DLookup  left hand bracket  Field Domain  Criteria -Right hand bracket close

The field simply any field you want return the value
Domain is any table or query value
Criteria allows to tell Dlookup which record to return.

I hope you like this tutorial

Thanking you

For more Pls visit mcitech

#dlookup#dlookupformaccess

• #education
• #dlookup_in_access_2007_with_example
• #dlookup_in_access_2007
• #dlookup_in_access_form
• #dlookup_in_access_in_hindi
• #dlookup_in_access_table
• #dlookup_function_in_access
• #dlookup_function_in_ms_access
• #dlookup_access