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