[AccessD] Dates As Criteria

Hi Mark

As Lambert wrote, just using Format leaves you with a string not a date.
If you have to - and I can't see that's the case here - you must use a US formatted string expression for a date value:

SELECT Format([ArrestDT],"\#m\/d\/yyyy\#") ..

/gustav

>>> markamatte at hotmail.com 14-02-2007 19:54:03 >>>
Thanks Jim...but that would cause a Circular Reference...I think??? And if I 
named ArrestDT something else...we are back to where I started...not 
returning the results I wanted.  This does disturb me a little be cause I've 
used FORMAT(DT_Field,"Short Date") a thousands of times...and never had this 
issue.  Using FIX does seem to 'fix' the problem...lol...I'm still 
confused...but ok.