I can't seem to get this syntax correct trying to use DateAdd as criteria with DLookup.
Here's what I think it ought to be:
DLookUp("SumOfHours","qryDailyTotal","[WorkDate]=#" & DateAdd('d',1,gStartDate) & "#")
with gStartDate being a date variable.
However I get "Expected: expression" Where...