Total / Summary based on a key field

[dumbass]

Hi,

I have 2 fields, date & time of an event .. I have a key that combines them both (date&time) ... we have a certain number of seats open for each timeslot for a day .. is there a way to add/summarize the total # registered for each key ?

w.r.t registration, each record is a registration and multiple people can be registered by the same person .. e.g. person x has a party of 5 ... and max people for that time slot is 100 .. i just want to display the total # registered for that time slot ..

e.g.

for date = 2/26/2008 and time = 10:30 AM, Total attending = attendance from record 1 + attendance from record 2 + etc. for that time slot .. .

i was wondering how to calculate the Total Attending in this case ..

[dumbass]

bump....

[comment]

I am not sure I follow your description that well. If you have a table of timeslots, and a relationship between that table and registrations (based on EventID and timestamp), you can get the total of registered by calculating Sum ( Registrations::PartySize ) from the timeslots table.

---

P.S. Bumping after 50 minutes??

[dumbass]

The thing is .. I'll have to manually create timeslot and date entries in the timeslot table for all possible combinations .. e.g. 30 days, 5 slots a day means 150 records .. this will just grow .. I was hoping for a concise solution .. where everything resides in the same table (registrations) and just calculate total attendance/registrations for each timeslot for that day ..

[comment]

You could have a fixed number of calculated slots (about as many as you can display at a time) displaying data from the selected period.

I don't see how you can this in a single table, other than by producing a report sub-summarized by timeslot.