Originally Posted by
Bob Fitz
In the query, replace: >[Forms]![reports f]![date]
with: >Format([Forms]![reports f]![date],"mm\/dd\/yyyy")
Read what Allen Browne says about international dates in Access. See:
http://allenbrowne.com/ser-36.html
BTW I would recommend you to redesign your tables which are not "Normalized".
As I suspected.
I used this constant in my DBs for such a reason.
Code:
Public Const strcJetDate = "\#mm\/dd\/yyyy\#" 'Needed for dates in queries as Access expects USA format.
as I could never remember the exact syntax. The I just used that as the format parameter.