Hi, I was wondering if it were possible to have a setting in a form, that changes according to the system clock? For example, the setting would be "Shift-First part" for anything done on Sunday. Then as Monday morning comes change the setting to "Shift-Second half". I am setting up a database to track information for employees who a day shift, a swing shift, and a grave shift. My only problem is querying the data for the shifts when the time transitions from one day to the other. I dont know how to differentiate pulling the data. I can only think of adding a setting that would mark each entry specifically for the part of the shift. Does this make sense?
FunkyG