OK, the Day1 field is text, a three letter abbreviation for the days in a week. Sun, Mon, Tue, Wed, Thu, Fri, Sat. Seven days. My original query where I used the code in Post #1 worked fine in Access 2010 but didn't work in Access 2019. The query from Isaac in Post #8 works in Access 2019 without the rest of the fields in my original query. To a layman like me with limited knowledge of coding, it would seem that there is a unknown difference between the 2010 and 2019 versions. So I opted for the simplistic approach as explained in Post #19. But it is "hagame loco" trying to figure out why the original query didn't work in the 2019 version when the change in the DaySort made it whole again.
But then it is solved, more than one way to solve a problem and if it works, who is to say my version is not better.
Thanks for all your help.