Show Count of items from a form

  • Thread starter Thread starter Conference Queen
  • Start date 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.
 
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.
 
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

Back
Top