Problem with sorting by Date only in DateTime field

[pclorikeet]

Hi! I have this very basic query:



where I am trying to sort records by descending Date. The field is defined as DateTime.
If it sorted correctly by DateTime then the results of the ID field which is an AutoID should be sorted from highest ID to lowest ID value, however this is not the case. It seems that Access is sorting by Date (and ignoring the Time component of the date). My datetime field only stores the date and not time, but I would have thought that in the background, Access would be storing a DateTime value, so that when I sort by Date Descending, it would actually sort by DateTime descending.

If it sorted by Date and Time then the ID field, by nature of it being an auto increment field, should have the highest ID at the top, to lowest ID.




Has anyone else experienced this?

Help !?!?!?

[alansidman]

If you are entering data in the date/time field and only entering the date and not the time, Access will assume that all time is midnight or 0:00:00 and will not distinguish between other date entries having the same date.

[pclorikeet]

Thanks!

You learn something new every day!!
I would have thought that Microsoft would have used date and time in the background ... but I can also understand why not !