AnsweredAssumed Answered

CliveB

Question asked by CliveB on Jan 20, 2013
Latest reply on Jan 21, 2013 by philmodjunk

Title

CliveB

Post

     I have a table containing various dates and a number of different names each of which is manually added. I have to produce a report that indicates the number of times a name appears in any given month in the current year (ie Jan, Feb, Mar etc). I have managed to produce a report that does this, however I can’t seem to get a total for each month.

     I have used COUNT function to get the number of times a name appears but using this overwrites any previous count for different name total fields.

     Is there a simple calculation method that could be incorporated in to a script to over come my problem?

Outcomes