I'm new to Ms Access (I'm a unix DBA for 20+ years) and have been developing a small app for a friend. Now i know that in Access you must use the US date format in queries, but I came accross this when my app was causing me grief ;
Table : timesheet
Columns : tsName,tsCode,tsDate,tsHours...