Evi:

This is another one of Access's little foibles to confuse us Yurpeans.  In
query design view dates are in the format of the local regional setting.  
This even applies to date literals delimited by the # character.  If you
switch to SQL view you'll see that its in mm/dd/yyy format there.

With a date like 24 April it doesn't matter of course as there is no month
24, but with a date like 5 April then #05/04/2008# this would usually be
understood to be 4 May regardless of the regional date format in use, but in
query design view does in fact represent 5 April where the regional date
format is set as dd/mm/yyyy in Windows control panel.

I do wonder whether MS simply overlooked this when 32 bit Access was
introduced.  In version 2 the regional setting was respected both in
functions like CDate, and in date literals using the # date delimiter
character.  With Access 95 date literals had to be in US short date or an
otherwise internationally unambiguous format.  Maybe they simply forgot to
change it in the query designer.  It doe seem to be a strange anomaly
otherwise.

Ken Sheridan
Stafford, England