Dates defaulting back to 2004

S

skmassih

I am trying to print a report that is based on a query that shows a date field formated as MMM-yy.
The condition in the query is to show records with transaction between 09/30/2004 & 10/01/2005. However the query always changes the 2005 to 2004 unless I change my short time from MMM-dd-yy. If I change the short time to MMM-dd-yy then my report will show the date as MMM-dd-yy. How can I fix this.
 
J

Jeff Boyce

How are you telling Access to use 10/1/2005 in your query? Perhaps Access
doesn't understand...

Please post your SQL statement for the query.
 
D

david epsom dot com dot au

You don't have to put the conditions on the same column as used by your
report.
Put in an unformatted date column to use as your criteria.


skmassih said:
I am trying to print a report that is based on a query that shows a date field formated as MMM-yy.
The condition in the query is to show records with transaction between
Click to expand...
09/30/2004 & 10/01/2005. However the query always changes the 2005 to 2004
unless I change my short time from MMM-dd-yy. If I change the short time to
MMM-dd-yy then my report will show the date as MMM-dd-yy. How can I fix
this.
 
Top