Automatic updates

[Eduman]

I have a database that keeps track of discipline. In a table Infractions,
there is a field Consequence. The consequences are based on the number of
demerits (one of three types of demerits). The consequences up to this point
are being entered manually. Every two weeks (pre-established by the staff),
the demerit count starts over. I currently run all queries, forms, and
reports by offering a start date and end date (the two week cycles) and then
use a between statement in my queries to help with organizing the demerits
for the current two weeks.

What I would like to do is be able to press a button and have the
consequences automatically entered based on the number of demerits reached so
far during the two week cycle. I would like to be able to keep this up daily
or everyother day as opposed to waiting for the two week cycle to be over.

Is there any hope? By the way, I am learning as I go. The more I check out
this community, the more I go back and streamline.

 

[Martin J]

I would seperate the function of clearing out after 2 weeks and calculating
punishments. To make it easier I'd create a control table where I'd keep a
date that the 2 week cycle is based on. Then you should be able to check back
to it on a daily basis if the cycle is up do both functions and enter new
cycle date or just calculate punishments if the cycle isn't up.

HTH
Martin J