View Single Post
  #1 (permalink)  
Old June 18th, 2003, 02:48 PM
dhborchardt dhborchardt is offline
Authorized User
Join Date: Jun 2003
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default Reoccurring events

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.