Report - counting each combo-box item

[DAmoss]

I have a combo-box named 'IDES' containing the following choices:

--------------------
Full-time Employment
Part-time Employment
Self-employment
Voluntary Work
FE, Training, Other Government Programmes
Unemployment
Other
Not known
Referred to Other Agency
--------------------

Is there a quick way of totalling all occurrences of each combo-box item from my records and showing those results in a report, or do I have to go about this using vba code first and then pass the results to the report.

eg. Count Field Choice
----- ------------
20 Full-time Employment
2 Part-time Employment
0 Self-employment
10 Voluntary Work .... and so on!

Any help given gratefully accepted, thanx

 

[snyperx3]

Im assuming the combo box is related to a field in your form, in which case you could use DCount.

A good resource:

http://www.techonthenet.com/access/functions/domain/dcount.php

This can be used in an unbound text box on your report.

-Pete

 

[DAmoss]

I know about the use of DCount, but I need to total each combo-box choice even if it is not picked in my records (eg. Total 0).

Is there a quick way to loop through the combo-box choices and then check each one against all my records giving a total for each and publish these totals in a report?

It looks like the only way I'm going to be able to do this is by using vba code.

 

[dhookom]

Isn't your combo box based on a lookup table? You should be able to create a query based on this lookup table and your other table. Set the join properties to display all records from your lookup table.

If you didn't use a lookup table, change your combo boxes to use one.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]