I have the below written as a criteria.. but its not working.. I have the format wrong i suppose.. It should work for a date range.
TmpDate1 = Format(Me.DateStart, "mm/dd/yy")
Tmpdate2 = Format(Me.DateEnd, "mm/dd/yy")
SQLDATE = "(((QuoteMain.[DateOfQuote]) BETWEEN & #" & TmpDate1 & "# & AND & #" & Tmpdate2 & "#))"
TmpDate1 = Format(Me.DateStart, "mm/dd/yy")
Tmpdate2 = Format(Me.DateEnd, "mm/dd/yy")
SQLDATE = "(((QuoteMain.[DateOfQuote]) BETWEEN & #" & TmpDate1 & "# & AND & #" & Tmpdate2 & "#))"