Hi,
I have a set of data which is imported and in the past has been sorted by date, this suits my purposes perfectly as the data is date format only with no time (it imports as a 00:00:00 time).
As the data has been imported in a correct order I could sort it by date and then primary key.
The data I receive is now changing to date and time and what I want to do is optionally sort by date and time or sort by date and primary key.
Basically, how do I sort by just the date part of the date and time?
I have a set of data which is imported and in the past has been sorted by date, this suits my purposes perfectly as the data is date format only with no time (it imports as a 00:00:00 time).
As the data has been imported in a correct order I could sort it by date and then primary key.
Code:
ORDER BY qryDone.SDate, qryDone.ID;
The data I receive is now changing to date and time and what I want to do is optionally sort by date and time or sort by date and primary key.
Basically, how do I sort by just the date part of the date and time?