The business that im creating a database for needs a automated way to control battery testing for its equipment.
basically there needs to be a query displaying the last 10 years of test results.
the test results arent an issue, its timing the replacement of batteries.
my client wants an alert to appear in the database when a battery is due for replacement, some batteries have 3 year lives, some have 5 year lives.
another predicament is, say if theres a storm, some of the batteries tend to die. if a battery that has a 3 year life span has been replaced, but gets fried by a storm 1 year later need the timer to reset from when the latest battery went in.
thanks for your help