trying to report individual & group averages

[denno]

I am setting up a database for tracking lectures and evaluations. One of the layouts is a letter that gives the speaker their average score on an evaluation form as well as the overall average for all speakers.

I have the mean score for the individual speaker displaying fine but I can't get the overall mean for the entire database to display--it only shows the speaker's individual mean.

I set up another layout that lists out all the evaluation scores and created a 'Composite Mean' calc field that displays the number I want. I tried using a set variable & set field script that retrieves this number then puts it into a field on the letter layout but when I do it displays the speaker's individual mean.

Thanks for any help you can offer...

[Vaughan]

It sounds like you need to use a Summary field. This will average whatever the current found set of records happens to be (which could be the whole database if you want).

[denno]

Yes--it is a summary field.

I came up with a workaround by copying/pasting from the overall average for all speakers onto the letter to the individual speaker.

Edited August 27, 2007 by Guest