Count results

[funkygoorilla]

Hi, I have three results that I would like to be able to count(total) for a report. But I don't know how to get my report to do so. The options are selected in a form from a drop down that has a table as a source. I would like to be able to show on the report how many times each option was selected.
For example; If the user selects Monday, I would like to be able to show how many Mondays were selected.
How can I do that?


Thanks, Funky G.

[hertfordkc]

Hi, I have three results that I would like to be able to count(total) for a report. But I don't know how to get my report to do so. The options are selected in a form from a drop down that has a table as a source. I would like to be able to show on the report how many times each option was selected.
For example; If the user selects Monday, I would like to be able to show how many Mondays were selected.
How can I do that?
Thanks, Funky G.

Perhaps when the form selections are made, and the report called, the report, during its open event, could look back at the choices made in the form and construct a filter, a query, a Dlookup....

[funkygoorilla]

So there is no way to just count how many times a choice from a drop down has been made?

[hertfordkc]

Since you are treating the choice as a data point, you need to save it as a field in a table.
Every time a choice is made, the values in the table gets updated. Use the Click event to do the processing.

[funkygoorilla]

Hertfordkc,

I like your idea, but I dont want to save the value in a table. I just need it to total in a report. Would it work in a similar way?

[hertfordkc]

If you only want to total during each time the data base is open as opposed to multiple times the data base is open.
BTW, tables are cheap.

[hertfordkc]

A better explanation for you.
Have the first opened form or macro set global counters to zero. These should be in a global module.
Thereafter, the onclick events will handle the incrementing of the counter. Then you can refer to it in your report.

[funkygoorilla]

Hi Hertfordkc,
I wound up going a different route than you suggested. I used this formula;
=Count(IIf([Call Type]="ABCD",0)) I put this in a new text box, and used it to count all the occurrences of the words I was looking for.
This did just what I needed it to. I appreciate your help on this though.
Thanks again!