J
John K
can anyone tell me what's wrong with this?
searchSQL = "Select * FROM Events WHERE Date >=#" & DateBegin & "# AND Date
<=#" & DateEnd & "# ORDER BY Date " & sort & ";"
I have a form sending the correct data but I can't get this to recognize the
'Date<=' For example, when I do a search and a date lands on the last day
of the month, it doesn't turn up. It reports the 'greater than or equal to'
but not the later. What am I doing wrong?
I'm not a SQL pro so don't kill me...
Thanks!!!
John
searchSQL = "Select * FROM Events WHERE Date >=#" & DateBegin & "# AND Date
<=#" & DateEnd & "# ORDER BY Date " & sort & ";"
I have a form sending the correct data but I can't get this to recognize the
'Date<=' For example, when I do a search and a date lands on the last day
of the month, it doesn't turn up. It reports the 'greater than or equal to'
but not the later. What am I doing wrong?
I'm not a SQL pro so don't kill me...
Thanks!!!
John