mrojas
Member
I'm building a simple MS Access front end application to display in a grid records from one table based date field using the Query Builder. So far I've been able to display all records in the dataset if I don't enter a parameter, but when I try to filter records with a date >= today, the query builder chokes.
Here's my query syntax:
SELECT Speaker FROM tblSpeakers WHERE TalkDate>=Now
The query works if I use a literal date such as TalkDate>=#12/10/2012# but not with anything else I can think of.
:uncomfortableness:
Here's my query syntax:
SELECT Speaker FROM tblSpeakers WHERE TalkDate>=Now
The query works if I use a literal date such as TalkDate>=#12/10/2012# but not with anything else I can think of.
:uncomfortableness: