DLookUP syntax question 1

[LD1010]

Thanks for reading my post.

I'm working on a Payroll Db. I need to capture on an entry form "frmLaborHrs" the "PayPerID" from "tblPayPeriods" where the "frmLaborHrs.LaborDate" (Date/Time field) is between "tblPayPeriods.PayPerStart" (Date/Time field) and "tblPayPeriods.PayPerEnd" (Date/Time field) .

Is this possible to do and if so what's the proper syntax? Any help would be much appreciated.

 

[PWise]

dlookup("PayPerID" , "tblPayPeriods" ,"#" & forms!frmLaborHrs!LaborDate & "# Between PayPerStart and PayPerEnd")

 

[LD1010]

Thanks PWise! Worked great. Appreciate your help.