p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access ASP (http://p2p.wrox.com/forumdisplay.php?f=104)
-   -   Reoccurring events (http://p2p.wrox.com/showthread.php?t=709)

dhborchardt June 18th, 2003 02:48 PM

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.

All times are GMT -4. The time now is 08:54 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.