DLookUp with two criteria

[Tim]

I have a table in my database called tbl_Users with field
names of "User_ID";"Monday";"Tuesday";"Wednesday" etc.
Each of the "Day" fields holds the number of hours each
individual works on that particular day. I want to write
a DLookUp query to bring back the number of hours
dependant on both the date entered and the User_ID.

The code below picks up the hours worked assuming the
date is a Monday, but how do I include the second
variable (which I have called HolDate)?

HolHours = DLookup("Monday", "tbl_Users", "User_ID = """
& Me!User_ID & """")

 

[Allen Browne]

HolHours = DLookup(Format(Date, "dddd"), "tblUsers, _
"User_ID = """ & Me.User_ID & """")