So I am at my last hurdle with what I am trying to do I believe. My query looks like the following.
Code:
SELECT tbl_StaffList.STAFFID, tbl_StaffList.Last_Name, tbl_StaffList.First_Name, tbl_StaffList.EOD, tbl_StaffList.Department, qry_LastAugment.Last_Augment
FROM tbl_StaffList LEFT JOIN qry_LastAugment ON tbl_StaffList.STAFFID = qry_LastAugment.STAFFID
WHERE (((tbl_StaffList.Augment_Status)=True))
ORDER BY tbl_StaffList.EOD DESC , qry_LastAugment.Last_Augment;
When it comes to the ORDER BY I am having the issue of it not listing properly or how I would like it rather. I want the query to list the results where the EOD date(Seniority Date) is from newest staff member to oldest staff member so in descending order. I then want it to order next by LastAugment date where the oldest augment date is first and newest is last otherwise Ascending order. With the ORDER BY that I am currently using it does that but if people have the same EOD date it keeps them grouped together which I dont want. Example below.
So in this image the middle column is the EOD field and the last column is the LastAugment field. That is how it currently displays but how I need it to actually display is the 10/5/2014 EOD that has a LastAugment of 10/11/2020 should now be at the very bottom as everyone else in the list should then get augmented in the order of their EOD date first then by LastAugment after before that staff member gets augmented again. This rotation is just on going then based off of last augment after all staff members have been augmented. Thanks for the help.