If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query- Totaling yes answer an the calcuating the percent of the to
I am trying to created a query that totals the number of "yes" answers in a
data base and then calculates the percent of "yes" versus the total of the "yes" and "no”. My questions in the DB have n/a and TDB as well for choices, so I need to exclude these in the roll up of question. |
#2
|
|||
|
|||
Query- Totaling yes answer an the calcuating the percent of the to
On Wed, 4 Feb 2009 09:44:03 -0800, EMall
wrote: I am trying to created a query that totals the number of "yes" answers in a data base and then calculates the percent of "yes" versus the total of the "yes" and "no. My questions in the DB have n/a and TDB as well for choices, so I need to exclude these in the roll up of question. If the datatype of the field is Text and you want to just consider the literal text strings "Yes" and "No", try =Sum(IIF([answer] = "yes", 1, 0) / Sum(Iif([answer] = "yes" OR [Answer] = "no", 1, 0) You may need some criteria to eliminate cases where there are no answers containing either yes OR no - you'll get a divide-by-zero error. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Query- Totaling yes answer an the calcuating the percent of the to
In the query criteria us Not Like n/a AND not like TBD
"EMall" wrote: I am trying to created a query that totals the number of "yes" answers in a data base and then calculates the percent of "yes" versus the total of the "yes" and "no”. My questions in the DB have n/a and TDB as well for choices, so I need to exclude these in the roll up of question. |
Thread Tools | |
Display Modes | |
|
|