Not sure if this would be done better as a stored proceedure in Access or query sent straight from the asp page:
What is the best way to handle events that are going to come up at sheduled times. For example I have a bunch of equipment that will need maintenance at different times throughout the year. An air handleing unit is going to have its filters swaped 3 times a year. When I entered this piece of eqipment into the database, the date field was set to now and the reoccurrance was set to 4 months. I want to be able to run a query that will show everything that has come up for maintenace and once I put a check in the finished box it will not come up again until 4 months have passed.
Thanks