I have an simple attendance database like the one shown here:
Date HrsAbsent(-) Balance HrsAccumulated(+)
7/05/10 0 480 0
7/12/10 8 472 0
7/19/10 3 469 0
7/26/10 0 480 12
8/02/10 4 476 0
8/26/10 2 480 12
The maximum number in the Balance column cannot be more than 480 at any moment, but should count down like in the example above and then accumulate up to no more than 480. Every month the employee accumulates 12 hrs but the Balance can not be more than 480 in any month.
How can this be handled in a form or query? Thanks in advance.