[AccessD] Date/Time Conversion

I have a table that has a date field that the input has been the date &
the time (Now()). I'm trying to build a report based on the results of a
query that the user inputs the date.

I have tried formatting the field by using "TransDate:
Format([DateOFMovement],"mm/dd/yyyy")", with the criteria "Between
[Start Date ie: 10/05/2005] And [End Date  ie: 10/06/2005]". 

So if the users input is 01/01/2005 for the first date and 01/10/2005
for the second, the query results include 2004 records also, but with-in
the month and day criteria... 

If I try to sort the results is ascending order on the date, it will
only sort on the month & day..

What am I doing wrong??


Robert Gracie
www.gbsysnow.com