Count of specific values in a field

[technoranger]

I want to develop a report from a database based on the count of specific values from three fields.

The database contains student records (2000). Each student is a member of 1 of 25 Schools (selected by a value list), is in 1 of 10 Programs (selected by a second value list), and is coded with 1 of 15 Federal Codes (selected by a third value list).

I want to generate a report that shows for each School the count of students in each Program, then for each Program, the count of students coded for each Federal Code.

What it might look like is:

School 1

Program 1 - 25

FC 01 - 3, FC 02 - 5, FC 10 - 20

Program 2 - 17

FC 03 - 6, FC 05 - 5, FC 10 - 6

etc. for each School / Program / Federal Code (FC).

Any suggestions?

I have the same need for reporting the results of a Likard based survey.

[danjacoby]

Create a calc field that concatenates all three fields, with some divider between them (i.e. CalcField = School & " / " & Program & " / " & FC).

Then create a summary field that equal the Count of the CalcField. Create a sub-summary part when sorted by CalcField.

Now you can sort on CalcField and view the result in preview mode. If you want just the totals, create a layout that has only the sub-summary part, with the CalcField and the Summary field in it.

There are other ways; this is just one suggestion.

HTH,

Dan