query if date equals ___

  • Thread starter Thread starter mark r
  • Start date Start date
M

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
 
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
Click to expand...

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.
 
Back
Top