sambo
Registered User.
- Local time
- Today, 03:08
- Joined
- Aug 29, 2002
- Messages
- 289
I want to find the location where posts were made in "tblHistory".
[DateMod] is the time stamp that the post recieved (using the Now() function at post time).
I am getting a syntax error in regards to my Dlookup Date when I run my query.
[DateMod] comes from a previous field in the query, is this bad?
Where: DLookUp("[Location]","tblHistory","[DateMod] = #" & [myDate] & "#")
[DateMod] is the time stamp that the post recieved (using the Now() function at post time).
I am getting a syntax error in regards to my Dlookup Date when I run my query.
[DateMod] comes from a previous field in the query, is this bad?
Where: DLookUp("[Location]","tblHistory","[DateMod] = #" & [myDate] & "#")
