Count Criteria in a Report or Query

[agrillot via AccessMonster.com]

I need to count the number of like responses for multiple fields.

I have two tables. One with questions and one with personal data. They are
joined by ptid.

I created a report which is grouped by Location. I now need to count the
number of times for each location a specific answer was given ex.
"Very Good" = 2
"Good" = 95
"Poor" = 12 etc.

I would appreciate any help.

I have created a count for each "location" and have tried multiple things
like =Count(IIf([2]='Good',1,Null)) however this returns "data type mismatch
in critiera expression"

I am somewhat new and not sure how to proceed.

 

[Guest]

have tried multiple things like =Count(IIf([2]='Good',1,Null))
Is '2' the name of a field? It seems so in your expression above.
Need input!
What is the field name that has your locations?
What is the name of the field that has the responses?

 

[agrillot via AccessMonster.com]

The table is Questions, field names are [1] [2] [3] ... [12], all fields
reference drop down menus containing Very Good, Good, Average, etc.

I have another table that contains ptdata, location, lengthofstay,
dischargedate.

I created a query that allows you to enter a date range. I created a report
which groups by location and gives a total count by location but I need to
know how many Very Goods, Goods, etc per location.

have tried multiple things like =Count(IIf([2]='Good',1,Null))

Is '2' the name of a field? It seems so in your expression above.
Need input!
What is the field name that has your locations?
What is the name of the field that has the responses?

I need to count the number of like responses for multiple fields.

[quoted text clipped - 14 lines]

I am somewhat new and not sure how to proceed.

 

[Guest]

Post your query SQL.
--
KARL DEWEY
Build a little - Test a little

The table is Questions, field names are [1] [2] [3] ... [12], all fields
reference drop down menus containing Very Good, Good, Average, etc.

I have another table that contains ptdata, location, lengthofstay,
dischargedate.

I created a query that allows you to enter a date range. I created a report
which groups by location and gives a total count by location but I need to
know how many Very Goods, Goods, etc per location.

have tried multiple things like =Count(IIf([2]='Good',1,Null))

Is '2' the name of a field? It seems so in your expression above.
Need input!
What is the field name that has your locations?
What is the name of the field that has the responses?

I need to count the number of like responses for multiple fields.

[quoted text clipped - 14 lines]

I am somewhat new and not sure how to proceed.