Order by Clause Causes new record to go to top of query

[SoftballSandi]

Would you be so kind to look at the below MS Access SQL statement and tell me
why when I add a record, it becomes the first record in the query table. This
is driving me crazy. I enter a record and it moves to the top. I have
never-ever encountered this and I have generated a lot of MS Access code.

SELECT tblTasking.TaskID, tblTasking.DON, tblTasking.Employee,
tblTasking.TaskStartDate, tblTasking.TaskEndDate, tblTasking.Task FROM
tblTasking WHERE tblTasking.DON= 405 AND tblTasking.TaskStartDate>
#10/21/2008# ORDER BY tblTasking.DON, tblTasking.TaskStartDate,
tblTasking.Task;

Does it have something to do with the ORDER BY datatypes being different?????
Thank you for your help if you can,

 

[Arvin Meyer [MVP]]

Try adding TaskID at the end of the Order By so it reads:

ORDER BY DON, TaskStartDate, Task, TaskID;