How about attendance? Seems an attendance table is needed for the class anyway… With and attendance table and also a promotion date table, you have all the needed information to make a simple calculation that will yield both “#Classes Since Promotion” and “Total @ of Classes”… probably possible to do it with sql alone… but i would be more comfortable just pulling the data with sql then using base code in a macro to calculate the numbers.
