I have a query
but am getting Syntax error in date in expression 'Date_Time >= #'.
I am sure I am just over looking something. Any help would be greatly appreciated.
Code:
strGetDailyRecsSQL = "SELECT LarqOrder, LarqSerial, Date_Time INTO tempExport FROM LarqData WHERE Date_Time >= #" & Format(dteLastExport, "mm-dd-yyyy") & "#;"
but am getting Syntax error in date in expression 'Date_Time >= #'.
I am sure I am just over looking something. Any help would be greatly appreciated.