I am fairly new to MS Access and VBA. I have an SQL I built searching a query I created. The sql is searching for records where BegDate >= ARCallDate and EndDate <= ARCallDate.
The SQL does not give an error but does not return any records. I use 1/1/2010 for the start date and 2/1/2010 for the end date and there are records with ARCallDate equal to 1/29/2010.
I placed FORMAT(SDATE, "MM/DD/YYYY") and that didn't do the trick either. The actual SQL is
"Select ARCallID, ARCallDate, ARCallTypeID, ARCustID, ARCallPerson, ARCallNote from fqry_ARCall_list where ARCustID = 20287 and (ARCallDate >= 01/01/2010 and ARCallDate <= 02/02/2009)"
When I run this SQL as a query, it returns 3 records. When I run this SQL in my VBA code, nothing returns. What am I missinig?