asked on ADO SELECT WHERE Date Between
I am getting a 'Syntax error in date in query expression' for the following SELECT stmt:
strSQL = "SELECT * FROM Tiko WHERE T_Date BETWEEN #"
strSQL = strSQL & dtStart & "# and #"
strSQL = strSQL & dtEnd & "# ORDER BY T_Date"
dtStart = Date & " 00:00:00 AM"
dtEnd = Date & " 11:59:99 PM"
Please help!!
thanx
strSQL = "SELECT * FROM Tiko WHERE T_Date BETWEEN #"
strSQL = strSQL & dtStart & "# and #"
strSQL = strSQL & dtEnd & "# ORDER BY T_Date"
dtStart = Date & " 00:00:00 AM"
dtEnd = Date & " 11:59:99 PM"
Please help!!
thanx
Microsoft AccessSQL
Last Comment
thenemesiz
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If both solutions work, I have no objection to your reopening the question and splitting the points.
ASKER
modus_in_rebus,
sorry about the points...am new here. How do I reopen the question?
sorry about the points...am new here. How do I reopen the question?
...both solutions work!
thanks