Show Count of items from a form

  • Thread starter Conference Queen
  • Start date
C

Conference Queen

Access 2007, I have created a 'simple' conference registration form with a
drop-down list of class options: morning workshops (drop down list 4 choices)
and then afternoon workshops (drop down list of 4 choices). The primary key
is the participant ID. There is no subform and everything is in one table. As
I register participants for the choices, I want to display the number of
individuals (count them)in each of these workshops somewhere on the actual
access form, so I can keep track of how many people I have in each of these
workshops. Is this possible? Simple? Please help.
 
G

Golfinray

Put a textbox on the form and make its control source =count(individuals)
You can change the label of the textbox to "Count of People" or whatever you
want. You can put four textboxes on there with control souce set for each
count.
 
C

Conference Queen

Where (in what section) on the form will I put the textbox? Also you stated
count 'individuals'...... remember that I am trying to count each item in a
dropdown field....the field is called 'morning workshops' with 4 choices
listed: workshop A, workshop B, etc.?

Please clarify. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top