I am feeling really stupid right now. I have data with ARCAll = 1/27/2010, 1/28/2010, 1/2/2010 and 1/29/2010.

I have the following query which retrieves no records:

SELECT fqry_ARCall_list.ARCallID, fqry_ARCall_list.ARCallDate, fqry_ARCall_list.ARCallTypeID, fqry_ARCall_list.BillCompany, fqry_ARCall_list.ARCallPerson, fqry_ARCall_list.ARCallNote
FROM fqry_ARCall_list
WHERE (((fqry_ARCall_list.ARCallDate)>=Format(1/2/2010,"mm/dd/yyyy") And (fqry_ARCall_list.ARCallDate)<=Format(2/2/2010,"mm/dd/yyyy")));


What am I missing?