I have a student records database where the student are separated into four different groups. The experiment for each group is decided by which week of the year it is. currently there is a name field, a group field, experiment field and a Week field. Currently the weeks (1-8) are selected manually from a pop-up menu. and the experiments assigned as a case clause for each week.
I want to automate the week selection process - I know term dates and therefore week numbers but I've hit a wall on this - any ideas