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

  • Thread starter Thread starter SoftballSandi
  • Start date Start date
S

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,
 
Try adding TaskID at the end of the Order By so it reads:

ORDER BY DON, TaskStartDate, Task, TaskID;
 
Back
Top