How do I count the number of attendees?

[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

 

[Ronald W. Roberts]

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

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