sorting by year

  • Thread starter Thread starter lane
  • Start date Start date
L

lane

I have a list in my database that contains the date in the
following format. 07/08/2001 The data was created in excel
about five years ago and then merged into access. The
dates are sorted by the day and month.
How can I sort this column by year from oldest to most
recent. I tried ascending and descending.
please assit!
 
dates are sorted by the day and month.
How can I sort this column by year from oldest to most
recent?
Click to expand...

Lane,
If the doesn't sort ascendingly when sorted, it is most probably stored as
text rather than as a date. You can create a sorted query by pulling in the
fields you want and then creating a calculated field as follows "DateSort:
Cdate(<field_name>)" and choosing ascending from the sort options for that
column (remove the quotes and replace <field_name> with the name of the
field). The other option is to change the data type for the field in
question.

Cheers,
Barron
 
Back
Top