Re: How do I count the number of attendees?
From: Ronald W. Roberts (rwr_at_robcom.com)
Date: 02/25/04
- Next message: David Habercom: "One line of code is killing me!"
- Previous message: anonymous_at_discussions.microsoft.com: "Problem with Switchboard Form"
- In reply to: Tracy: "How do I count the number of attendees?"
- Next in thread: Graham Mandeno: "Re: How do I count the number of attendees?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 16:08:32 -0500
Tracy wrote:
>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
-- Ronald W. Roberts Roberts Communication rwr_at_robcom_dot_com@robcom.com To reply remove "_at_robcom_dot_com"
- Next message: David Habercom: "One line of code is killing me!"
- Previous message: anonymous_at_discussions.microsoft.com: "Problem with Switchboard Form"
- In reply to: Tracy: "How do I count the number of attendees?"
- Next in thread: Graham Mandeno: "Re: How do I count the number of attendees?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
