I have a number of fields in a table that contain values ranging from 1-5. What I need to do is count the number of times each value is used in each field.
I can do it for one field in a totals query by putting the field in twice and setting one field as "count" and the other as "group by."
And, I can do it in a report by putting text boxes and setting the control source as a dcount expression.
But, there are several dozen of these fields and I am hoping for an easier way.
I keep thinking a crosstab query would work, but haven't had much luck. Ultimately, that is the format I am looking for:
Field names as Row Headers, values as column headers and totals as the data.
Anybody have any ideas?
Thanks,
Neal
I can do it for one field in a totals query by putting the field in twice and setting one field as "count" and the other as "group by."
And, I can do it in a report by putting text boxes and setting the control source as a dcount expression.
But, there are several dozen of these fields and I am hoping for an easier way.
I keep thinking a crosstab query would work, but haven't had much luck. Ultimately, that is the format I am looking for:
Field names as Row Headers, values as column headers and totals as the data.
Anybody have any ideas?
Thanks,
Neal