Trocergian
Registered User.
- Local time
- Today, 02:39
- Joined
- Apr 6, 2009
- Messages
- 16
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:
with gStartDate being a date variable.
However I get "Expected: expression" Where am I going wrong?
Here's what I think it ought to be:
Code:
DLookUp("SumOfHours","qryDailyTotal","[WorkDate]=#" & DateAdd('d',1,gStartDate) & "#")
with gStartDate being a date variable.
However I get "Expected: expression" Where am I going wrong?