Problem with filtering on DATE Variable

[SIGMA248]

I am running the following code in MS Access 2003:



DoCmd.OpenReport stDocName, acPreview, , "[Equipment Number] ='" & temp & "' & [In] >#" & Format(temp_2, "mm/dd/yyyy") & "#", , temp_2

The problem is that no data is being shown on the report no matter what the [In] Date Variable is.

[ssanfu]

DoCmd.OpenReport stDocName, acPreview, , "[Equipment Number] ='" & temp & "' & [In] >#" & Format(temp_2, "mm/dd/yyyy") & "#", , temp_2

Try:

DoCmd.OpenReport stDocName, acViewPreview, , "[Equipment Number] ='" & temp & "' AND [In] > #" & Format(temp_2, "mm/dd/yyyy") & "#", , temp_2


The ampersand ("&") is used to force string concatenation of two expressions.

The "AND" operator is used to perform a logical conjunction on two expressions


You might also have problems because "IN" is a reserved word in Access. For a list of reserved words, see

http://allenbrowne.com/AppIssueBadWord.html