Date sort/truncates?

  • Thread starter Thread starter davidsrebro
  • Start date Start date
D

davidsrebro

Help, I'm a new user of access. Modifying an existing database. The
sort is on a date field, but the ordering is wrong:

9/1/05
9/16/05
9/2/05
9/22/05

In the query table it is correct, but in a report it is wrong. Why? Can
I just add an expression somewhere? Thanks in advance.
 
It looks like your field is text datatype field and is sorting correctly for
text. In text sort the four characters of 9/16 will be before the four
characters of 9/2/.

You should change the field to datatype DateTime.

You can sort the text field correctly if you use CVDate([YourField]).

You say “In the query table it is correct…†What does ‘query table’ mean?
 
Back
Top