sql_select = "SELECT examID, examName FROM tbExam where dateAvailable >= " & date() & " and timeAvailable >= " & FormatDateTime(now(),vbshorttime) & ""
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'dateAvailable >= 5/20/2008 and timeAvailable >= 15:37'.
the comparing of date works fine but the comparing in the time is making the syntax error.
have already tried using shorttime and long time but its still not working
i'm using microsoft access 2000 format by the way for my database