Summary Report 1

[adowen]

I have a mixture of tables, a [People] table that holds information as well as a [Meeting] table that holds information specific to the person and what they did that day. I have created a query to allow me to select a range of dates from [Meeting] for all [People]. I need to create a summary report over [People] so that it only lists a single record in the detail per person, totalling some fields inside the [Meeting] (i.e. Points, etc) table.

What do I need to do to create a summary report so that it will summarize multiple records before printing?

Thanx in advance,

aowen

 

[cali99]

Create a report where you group by the person's name (or other unique identifyer). You can place a field in the detail section that you want to sum on (say points) then set the visible property of the detail section to no.

Place the person's name or other fields about that person that you only want to print out once in the footer section of the person group.

Add a calculated field for any fields you want to sum - something like =sum([points]). This should print the total of the points field. Set the running sum property of this calculated field to over group to reset the counting after each person's record is printed.

Hope this helps!

Cindy