need a running total and when 2000 is reached i need it set back to 0

[marklane21]

here is the info needed table name is employee time and fields are employee name, date, total hours.
i need a running total until 2000 hours are reached and then i need it reset to 0. also any hours over the 2000 need to be added to the 0 in other words if on a wednesday the employee reaches 2006 then i need to start at 6 instead of 0 otherwise if it is exactly 2000 i need it go to 0. can anyone please help.

thanks and GOD bless,

Mark Lane

 

[shadow9449]

here is the info needed table name is employee time and fields are employee name, date, total hours.
i need a running total until 2000 hours are reached and then i need it reset to 0. also any hours over the 2000 need to be added to the 0 in other words if on a wednesday the employee reaches 2006 then i need to start at 6 instead of 0 otherwise if it is exactly 2000 i need it go to 0. can anyone please help.

thanks and GOD bless,

Mark Lane

Mark:

Have you considered using the modulus (MOD) operator?

SHADOW