query if date equals ___

[mark r]

A query has a where clause for date

Where (datefield = variablename)


If I type 11/03/2002 at the msgbox prompt, it doesn't work.
Nor does 11/3/2002

 

[John Vinson]

A query has a where clause for date

Where (datefield = variablename)


If I type 11/03/2002 at the msgbox prompt, it doesn't work.
Nor does 11/3/2002

You may need to delimit the date value with #. What's the datatype of
variablename? And what's the context - a SQL query has no way of
seeing the values of VBA variables; please post the code snippet.