Calculation formula needed please
I just can't seem to be able to work this one out. I have two tables, the first listing instructors. The second listing their pupils. I want a auto enter field in the instructors table which gives a count of new pupil records created say between 1/12/2012 - 31/12/2012. I intend to have a field for each month. Each pupil record has a field as an auto enter for creation date.
If this is possible, could you please give the formula to enter in the auto enter calcualtion box please.