SQL Statment

Hi,

"select * from " _
& "tablename where " _
& "date = #3/09/98#"

How to pass a date variable, instead of passing the date directly. When I try to pass a variable I am getting a error that the data type mismatch. Please its a important for my job. Any help will do. Advance thanks.

[ruggerid]

First off, change your fieldname "date" to "dtmDate".

Next dimension a variable "dtmDateVar" as Date.

"Select * From tablename Where dtmDate = #" & format(dtmDateVar, "mm/dd/yy") & "#;"

That should do it.