I have a form called frmPeople on which is a sub form called sfrmBradford (This is in datasheet view.) This is to calculate a thing called the Bradford Sickness Absence Score. which is the number of occurrences in the last 12 months squared times the number of days absent.
For example O is occurances and D is days absent so.. 2 occurrences of five days each will be O^ x 10 or 4 x 10 = 40. This is a rolling calculation over the preceding twelve months.
On the sfrmBradford are the fields First Day Off and Date Returned (both dates) and a Datediff calculation for the number of days absent.
I would like to have, on the frmPeople, a calculated field that shows the running Bradford Score for an individual.
The pic at the bottom is a mock up of what I need.
Any help would be greatly appreciated.
For example O is occurances and D is days absent so.. 2 occurrences of five days each will be O^ x 10 or 4 x 10 = 40. This is a rolling calculation over the preceding twelve months.
On the sfrmBradford are the fields First Day Off and Date Returned (both dates) and a Datediff calculation for the number of days absent.
I would like to have, on the frmPeople, a calculated field that shows the running Bradford Score for an individual.
The pic at the bottom is a mock up of what I need.
Any help would be greatly appreciated.