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.