Hi Everyone

I need an SQL statement where a variable will control WHERE clause

For instance

SQLstr = "SELECT * FROM tblJob WHERE Date > #10/26/2007#;" it works

but I want to use a variable instead of the date.

Something like this
n = #10/26/2007#
SQLstr = "SELECT * FROM tblJob WHERE Date > n;"

Is it feasible?

Hi

This should work

SQLstr = "SELECT * FROM tblJob WHERE Date > #" & n & "#"

Thanks
:)

Actually, since Date() is an Access function, it really should be taken OUTSIDE the quotes, that is...

SQLstr = "SELECT * FROM tblJob WHERE [n] < #" & Date() & "#"

where n is a field in the table. Note: If Date is a field you made up, then change its name. Date() is an Access function, and having a field with the same name will cause problems.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division