Search results

So, Say today was (is) the 5th of May 2023. The calculation hast to be the previous 12 months back to the 5th of May 2022 on a rolling bases so tomorrow it will go back to the 6th of May 2022 etc. Any sickness absence that was in progress at the time of this date would be ignored. Its total...

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...

Thank you. I can certainly work with that :)

Ok Cell O4 is a calculated age. Range C8:C17 is age ranges 18-24 25-29 30-34 35-39 40-44 45-49 50-54 55-59 60-64 65+ Id like to be able to highlight the row based on the value in O44 Can this be done? Thanks Guys Steve