### Title

How to count discrete values from separate fields?

### Post

Greets, all:

I'm short of coffee this morning so maybe that's why I can't find/figure out an answer to a problem I need to solve: I need to count the number of discrete values from separate fields; I've found info on something like it on the Web for when you want to count discrete values in _one_ field but not from _many_ fields.

Example: You have five fields, each one assigned a numerical value:

DB1 = 1

DB2 = 3

DB3 = 2

DB4 = 3

DB5 = 1

So, the result I'm looking for should look like this:

Count of 1s: 2

Count of 2s: 1

Count of 3s: 2

Count of 4s: 0

...etc.

Suggestions and help will be greatly appreciated. Thanks!

That still does not rule out using a related table. Each record can have:

An fk field to match to the parent

A RatingType field with "Skill", "Presentation", "knowledge", etc

A RatingValue field with the actual rating

This is sounding more and more like a survey/audit/questionaire type project. If so, you might check out this thread: Need aid on generating a report from a survey layout.