Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to sort my data ascending using the date field that is formatted as
follows 29/8/05. Access sorts all dates first by day and then all dates by
month but does not sort by year. So that with a series of dates eg. 02/08/05,
03/08/05 and 04/08/04. Access will not place the 04 year first in the sort it
will follow 03/08/05. Can I get Access to read the whole date. Can I change
the date formatting to acheive my aim?
 
Its a while since I used A97, but in A2K provided date field is a
'Date/Time' field, formated in shortdate, the sort order will be correct -
leastways it is in my app -
 
It sound like you date field type is string and not date, either change the
type to date or in the query convert the field to date

Select DateField From TableName Order By CVdate(DateField)
 
Back
Top