Between formatting

[reidn]

I have a form where you select a month to see records from. This would not be a problem accept for the date/time is recorded as


MM/DD/YYYY 00:00:00 AM. I am trying to write a between statement that looks like this...

WHERE QA_Packaging.Date Between "[forms!Scores!MonthConv]/1/[forms!scores!Year] 00:00:00 AM" And "[forms!Scores!MonthConv]/31/[forms!scores!Year] 11:59:59 AM";

The MonthConv is a textbox that converts the month selected to a number, 1, 2, 3 etc... and Year is the year selected. Am I formatting it wrong?

Thanks in advance for the help

[vicrauch]

If you are dealing with dates, rather than using the double quotes you have shown here, you need to have the hash symbol on each side of a date.
"[forms!Scores!MonthConv]/1/[forms!scores!Year] 00:00:00 AM" should be:
"#" & Forms!Scores!MonthConv & "/1/" & Forms!scores!Year & " 00:00:00 AM#"

[reidn]

I tried that and its response was "This expression is typed incorrectly or it is too complex to be evaluated". I know the rest of the SQL is correct...