Counting Text

J

joanne.hon

A column in my subform (subform named "Enrollments SubForm1" contains a
combo box with four options: "registered", "Waiting List", "Cancelled"
and "Attended".

I would like to count the number of times that a particular course
record contains the word "registered" "Waiting List"....etc.

Then I would like to run a report which shows each course the
associated number of "Registered", "Waiting List" etc.

Any ideas?
 
J

John Vinson

A column in my subform (subform named "Enrollments SubForm1" contains a
combo box with four options: "registered", "Waiting List", "Cancelled"
and "Attended".

I would like to count the number of times that a particular course
record contains the word "registered" "Waiting List"....etc.

Then I would like to run a report which shows each course the
associated number of "Registered", "Waiting List" etc.
Click to expand...

The data is NOT in your subform. It's in a Table.

Create a Query based on this Table (whatever table it is) - or a query
joining this table to your Lookup Table (if you have one) to pick up
the option name - and change it to a Totals query by clicking the
Greek Sigma icon (looks like a sideways M).

Select the Option Name field and the Course field; select one of them
twice. Use the default Group By on the COurse and the Option, and
choose Count on the other field.

Open the query as a datasheet and you will see the course, the option,
and the number of times that option was selected for each.

John W. Vinson[MVP]
 
Top