How do I count the number of attendees?

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have a database set up for registering attendees to a
conference. The conference is over a few days so
attendees get to choose which workshops they go to.
My problem: How can I keep track of how many people have
registered for a particular workshop as the registrations
come in and they are entered into the database?

All suggestions welcomed.

Thanks
Tracy
 
Tracy said:
I have a database set up for registering attendees to a
conference. The conference is over a few days so
attendees get to choose which workshops they go to.
My problem: How can I keep track of how many people have
registered for a particular workshop as the registrations
come in and they are entered into the database?

All suggestions welcomed.

Thanks
Tracy
Click to expand...
You need to create a query that uses Totals. Add fields to the query
and set the
to GroupBy. Items such as course number, Term and year, and so on. Then
add fields that have some criteria you need, suh as status Active. Then
add a field
you want to set to Count. It can be the course number or first name or
any thing that
is part of this query.

I try to make these as small as I can. What I mean by that is I keep
the number of fields
to a very Min. Then I join this query to a course master table or
query. The new query will
give you what you want for reporting class or course counts (registrations).

Ron
 
Hi Tracy

I'm going to have to make some assumptions here about your table structures.

Let's say you have a table of People (with a primary key PersonID) and a
table of Workshops (with a primary key WorkshopID). Because there is a
many-to-many relationship between these two tables (many people attend a
workshop and a person can attend many workshops) you need to have a third,
"conjunction" table, WorkshopRegistrations, with fields for a PersonID and a
WorkshopID. It might also contain fields *specific to that registration*,
such as confirmation status, payment status, etc.

Now, the number of registrations for a particular workshop is simply a count
of the number of records with the corresponding WorkshopID. You can get
this in a number of ways - here are a few:

1. For a quick one-off count, of a single workshop, use DCount:
DCount( "*", "WorkshopRegistrations", "WorkshopID=23" )
Of course, the "23" here would not be hard-coded - it would come from
somewhere else, like a combo box on a form.

2. Make an aggregate query to return the counts for all workshops:
SELECT WorkshopID, Count(*) as Registrations
from WorkshopRegistrations group by WorkshopID;

3. If you have a form based on Workshops with a linked subform based on
WorkshopRegistrations then you have a good tool for adding registrations to
a particular workshop. You can add to the header or footer of the subform a
textbox with the ControlSource: =Count(*) and that will display the number
of registrations for the current workshop.

Hope this has given you a few ideas.
 
Back
Top