AnsweredAssumed Answered

Calculation formula needed please

Question asked by JoChapman on Jan 3, 2013
Latest reply on Jan 3, 2013 by philmodjunk


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.