add a formula to a prexisting query that will count

[M&M_New@this]

Good Morning,

I am trying to update an existing report based on an existing query. The
additional field includes data (made of scores) that are both numbers and
text. The field type is text. I need to be able count the total of
different scores by both numbers and letters.

My approach is to set up an additional field in the query for each number
and letter score type. The problem is how do I get access to count the
different scores per each ID type?

I am not very experienced. Can someone help please me?

I would greatly appreciate it.

Maria

 

[KARL DEWEY]

Use calculated fields in a totals query --
Grade A: Sum(IIF[Grade] ="A", 1, 0))
Grade B: Sum(IIF[Grade] ="B", 1, 0))
Grade 5C: Sum(IIF[Grade] ="5C", 1, 0))
Grade 6B: Sum(IIF[Grade] ="6B", 1, 0))
etc.

 

[M&M_New@this]

Good Afternoon Mr. Dewey
Thank you for your quick response to my inquiry. I tried the formulas in my
query with no success.

It returns an error message "You must enclose IIF function arguments in
parenthesis. I added a parenthesis is several places with no success. What
am I doing wrong?
--
M&M_New@this

Use calculated fields in a totals query --
Grade A: Sum(IIF[Grade] ="A", 1, 0))
Grade B: Sum(IIF[Grade] ="B", 1, 0))
Grade 5C: Sum(IIF[Grade] ="5C", 1, 0))
Grade 6B: Sum(IIF[Grade] ="6B", 1, 0))
etc.
--
KARL DEWEY
Build a little - Test a little

Good Morning,

I am trying to update an existing report based on an existing query. The
additional field includes data (made of scores) that are both numbers and
text. The field type is text. I need to be able count the total of
different scores by both numbers and letters.

My approach is to set up an additional field in the query for each number
and letter score type. The problem is how do I get access to count the
different scores per each ID type?

I am not very experienced. Can someone help please me?

I would greatly appreciate it.

Maria

 

[M&M_New@this]

Mr Dewey,
I found my error and corrected the parenthesis. Now a get an error message
that states you cannot use an aggregate function in this expression.
--
M&M_New@this

Use calculated fields in a totals query --
Grade A: Sum(IIF[Grade] ="A", 1, 0))
Grade B: Sum(IIF[Grade] ="B", 1, 0))
Grade 5C: Sum(IIF[Grade] ="5C", 1, 0))
Grade 6B: Sum(IIF[Grade] ="6B", 1, 0))
etc.
--
KARL DEWEY
Build a little - Test a little

Good Morning,

I am trying to update an existing report based on an existing query. The
additional field includes data (made of scores) that are both numbers and
text. The field type is text. I need to be able count the total of
different scores by both numbers and letters.

My approach is to set up an additional field in the query for each number
and letter score type. The problem is how do I get access to count the
different scores per each ID type?

I am not very experienced. Can someone help please me?

I would greatly appreciate it.

Maria

 

[Lord Kelvan]

you have to add group by for the rest of your formulas

Regards
Kelvan