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?