counts

[denno]

I am trying to create an email that will tell people how many hours of lecture they have attended year to date.

The setup is a bit hard to explain but here goes:

1. each attendee fills out an evaluation form for each hour of lecture they attend

2. their name & score on the eval form are entered into the database

3. i created a field named "hrs count" that does a running count of name

4. i created a layout that displays each lecture date and each attendee's name & hrs for that date. (Date is in leading grand summary. Name & "hrs count" are in a subsummary by name)

I would like to be able to have a cumulative tally of hrs for each attendee so (a) I can display a report of all attendees & their totals (: I can email to each individual their own total.

Thanks for any help...

[Vaughan]

"i created a field named "hrs count" that does a running count of name"

This should probably be a Total, not a running count.

However, much depends on how your data is structured: you should have an "attendee" table where each record is a person, and a "lecture" table to hold the lectures that they have attended. With this structure, it should be very easy to calculate how many hours each person has attended.

[denno]

This should probably be a Total, not a running count.

Edited August 27, 2007 by Guest

[denno]

OK--somehow I got it to do what I want, both in the report and by email. Just took some more trial & error...