Just sort on whatever field signifies the shift, then also sort on the DateTime field.
Example: ShiftID, ShiftDateTime

Just to add to Kevin's post.  If I have a field like that that I want to name but the names don't sort alphabetically you could do one of two methods.

1. Create a lookup table  ShiftT  In this case DON'T make a Primary Key that is Autonumber
      Do make it Indexed No Duplicates

   Fields:  
       ShiftID  as Long  PK
       ShiftName as Short Text
       Description
  
   Data:
      1      Day Shift     Description
      2      Afternoon Shift     Description
      3      Evening Shift     Description
     ...      Other shifts     Description
      7      Late Evening  
      8      Over Night

(or what ever you name them)
Then #1 you avoid duplication of data since you use the ID  AND
        #2 you can sort on the ID to suit your needs.

The other method I use is to add a SrtSeq field as Long  (Sort Sequence - just my naming ) and use that field to sort with.
If I do it this way I create the Autonumber field for my ID.

      

Hey Scott and Kevin. Thanks for letting me know, the advise and tips. To let you know I am only a biginner is code. I would like to advance in it but expenses too low because of car repair and family. You guys are more advanced in it. I only got to video 4 of the expert series and can't go any further because of our nonprofit organization's budget. I'll ask Frank about this way but the way he explained it we need to see the people on what shift and the shifts that need to be filled. This is only for our calendar since it only has 5 fields and 2 of them are "shift" and "P" for primary. We need to see what shift the people are on and if they are filling in for someone else. I'll ask him.

You shouldn't need any advanced programming to do this. Both solutions are simple enough.

Hi Richard, simple for people who know VBA code. I am only beginning in code but learning as I go.

You've got Developer 1. That's the best place to start. Keep truckin'. :)