I am trying to pull all records with dates less than a given date here is the sql I have created
strSQL = "INSERT INTO ReportTableTemp SELECT * FROM [Billinginfo Query] Where [JobId] = " & JobId & " And [JobDate] < " & MaxDateReport & ""
which generates the following statement
INSERT INTO ReportTableTemp SELECT * FROM [Billinginfo Query] Where [JobId] = 18 And [JobDate] < 11/19/2002
I have records in the table Billinginfo Query with dates less than 11/19/2002 and these dates are stored in the same format as '11/19/2002'
but the statement does not work, in other words it does not 'pull' any records out of the table
why
thanks
strSQL = "INSERT INTO ReportTableTemp SELECT * FROM [Billinginfo Query] Where [JobId] = " & JobId & " And [JobDate] < " & MaxDateReport & ""
which generates the following statement
INSERT INTO ReportTableTemp SELECT * FROM [Billinginfo Query] Where [JobId] = 18 And [JobDate] < 11/19/2002
I have records in the table Billinginfo Query with dates less than 11/19/2002 and these dates are stored in the same format as '11/19/2002'
but the statement does not work, in other words it does not 'pull' any records out of the table
why
thanks