Quote Originally Posted by Banjo View Post
It's hard enough making it work as a report within Facility as % att is calculated on the fly rather than stored against a pupils in the DB, let alone having to write some VBA in Access that looks up dates and records across half a dozen tables.
Other than a complete years historical data, Attendance as a % pretty much has to be calculated at or for the time the question is asked - it would be the same with any schema.

I did some work on attendance, it may be incorporated into the code here. I'd need to check though - it may have been a subsequent update.