Access and Cicode have different Date/Time variables data types. Date references in an external database has to be based on the Gregorian Calendar.
You can convert between date and time in three ways:
AccessTime = 25568.66667
+ (CicodeTime/86400);
CitectTime = 86400*(AccessTime - 25568.66667);
SELECT * FROM qryMyQuery WHERE 'Date' BETWEEN #3/20/96# AND #3/27/96#
The American Date format is used in this case, the Jet Engine DLL ignores the local Date and Time settings as set in Windows Control Panel.