Summary of a summary?

[Evergreenh]

I might be being a bit dumb asking this question but I’m totally stumped and would appreciate some help.

I have a table which is made up of event records. Then I have a report layout which shows a lot of numerical information about these events, with a summary for each field. Let me show you a simple example

Event 1 (field 1 = 10)

Event 2 (field 1 = 9)

Event 3 (field 1 = 20,)

Trailing summary - (Summary of field 1 = 39)

So for example I have 45 events each month. Each event record has a field that gives me ‘Total Attendees’ for that specific event and another for date of the event. So the layout above would list the events in any selected month, and I have a summary field that shows the ‘Total Attendees’ for all events added up within that month within the trailing summary. But what I want to do is to create a report that shows the summary fields so that I can compare the ‘Total Attendees’ each month.

So something like this:

For all events within Jan (Summary of field 1 = 39)

For all events within Feb (Summary of field 1 = 47)

Hope Im making sense. It occurred to me that what I want is another field that does something like the following:

Show a summary of ‘Summary of field 1’ when the month of event = xxx

But of course since the field ‘Summary of field 1’ is dependent on a set of found records that I don’t actually want to find and show.. that is impossible. I want to be able to display the summary fields at the bottom the report for January, and show them on a report next to the same information for February, March etc

Can someone help out?

[Vaughan]

Summarise the report my year/month as well. (Don't just summarise by Month because you'll get all records for January 2008 and 1009, etc.)

[Evergreenh]

Oh thank you very much for your reply.

I will give that a go and see how it works out

Kelly

X