add a formula to a prexisting query that will count

  • Thread starter Thread starter M&M_New@this
  • Start date Start date
M

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
 
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.
 
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


KARL DEWEY said:
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


M&M_New@this said:
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
Click to expand...
Click to expand...
 
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


KARL DEWEY said:
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


M&M_New@this said:
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
Click to expand...
Click to expand...
 
Back
Top