Dlookup on Multiple Criteria

[AndrewKent]

Hi guys,

I want to DLookup a value from one table to bring into a Select Query based on Multiple Criteria. Basically I want the Query to do the following

Where the value in:

[tblData_StaffDatabase]![SDB_EmployeeNumber]

matches:

[tblData_ChangeLog]![CL_EmployeeNumber]

AND

[tblData_ChangeLog]![CL_Week] = 26 **numerical value**

AND

[tblData_ChangeLog]![CL_Year] = "2011-2012"

then return:

[tblData_ChangeLog]![CL_OracleCCNumber]

Can anyone help?

Kind rergards,

Andy

 

[AndrewKent]

Got it:

Previous Cost Centre Number: DLookUp("[CL_OracleCCNumber]","[tblData_ChangeLog]","[tblData_ChangeLog]![CL_EmployeeNumber]='" & [tblData_StaffDatabase]![SDB_EmployeeNumber] & "' AND [tblData_ChangeLog]![CL_Week]=26 AND [tblData_ChangeLog]![CL_Year]='2011-2012'")

Cheers,

Andy

 

[AndrewKent]

Now,

How do I change the 26 to show an input box? So that I can determine a number?

Kind regards,

Andy

 

[boblarson]

Now,

How do I change the 26 to show an input box? So that I can determine a number?

Kind regards,

Andy

Previous Cost Centre Number: DLookUp("[CL_OracleCCNumber]","[tblData_ChangeLog]","[tblData_ChangeLog]![CL_EmployeeNumber]='" & [tblData_StaffDatabase]![SDB_EmployeeNumber] & "' AND [tblData_ChangeLog]![CL_Week]=" & CInt([Enter Week Number]) & " AND [tblData_ChangeLog]![CL_Year]='2011-2012'")

 

[AndrewKent]

Cheers muchly!