Wayne,
We have 3 separate lists, one for each rank of Captain, Operator, and Firefighter. People are listed in order of when they last accumulated 24 or more hours of overtime. The most recent person to accumulate 24 hours of overtime will be the last person on the list. When an overtime coverage is needed the BC (battalion chief) will go down the list and offer overtime to people that are available to take overtime. The person first on the list may be working that day or on annual leave or for what ever reason can not work that day. So the BC continues down the list. When he finds a person to accept the overtime, it may be a full shift, 24 hours, in which case they will go to the bottom of the list from where ever their current position on the list is. If the overtime is a partial, say 10 hours, then they will not move from their current position unless they have previously accumulated 14 hours or more and therefore going over 24 hours. At which point they will be moved to the bottom of the list. Once you are moved to the bottom all hours are reset to 0.
This a can be a very lenghthy proccess for the BC. We currenty are using a card file but mistakes can be made trying to track hours and positions.
I have made an inventory progam in Access that seems fairly complicated, to me at least. So my BC was hoping I could put something together for the overtime list. I have been able to get by with just some basic Access training. I have used macros to do most of the code work I guess. I do not know VBA, which is probably where this progam will have to be soved.
Thanks again for your time.
Mike