Hi,

You can use # character to enclose dates. like #01/22/2006#. In this way, month comes first always.

Please verify this because I worked with MS Access long back and with older versions.

Regards

Kish.