Database sorts dates wrong

[douglasw32]

Access is not being nice to my newest report.

Can anyone help (this has to be simple) compared to some of the help I have gotten here.

It would seem that if the date is for example- 11/22/2006 and the most recent race is 6/4/2007 the 11 is counted before the 6

It seems to not be sorting by date but by the first digit.

I am pulling DRF files into access.

I need the group sort by FIRST to actually be the first date and it is more often than not, but sometimes throws up a 10,11, or 12 in front of what is needed.

Help ???

[BillW]

Looks like the format of the field holding the date is mis-defined (possibly as "text"). Change it to "date" and see if that helps.

Access is not being nice to my newest report.

Can anyone help (this has to be simple) compared to some of the help I have gotten here.

It would seem that if the date is for example- 11/22/2006 and the most recent race is 6/4/2007 the 11 is counted before the 6

It seems to not be sorting by date but by the first digit.

I am pulling DRF files into access.

I need the group sort by FIRST to actually be the first date and it is more often than not, but sometimes throws up a 10,11, or 12 in front of what is needed.

Help ???

[OTM Al]

That is definitely the problem. Make sure to back up before you change though, just in case.

[douglasw32]

Field 7 Formulator Running Line Export, Linked Table, Set as Date/Time

???????

Thanks for the ideas, but nope :( it perplexes me...

[BillW]

I just re-read your original post. 11/22/2006 should be sorted before 6/4/2007 in an SQL default ascending order sort. Maybe all you need to do is change the sort order to descending if you want it the other way?

[douglasw32]

BINGO! That is it BillW Thanks again !

[OTM Al]

D'oh!!!!!!!!!! Occam's razor strikes again!

[douglasw32]

The explanation of any phenomenon should make as few assumptions as possible.

I like that.