I have a db with a bit of yes/no/na drop downs. I have those drop downs pulled into queries to produce the % for each of the records. Everything is fine and dandy till I try to pull a report that has a "N/A" as an answer in the table. It then gives me this error
"This expression is typed incorrectly, or is to complex to evaluated...blah blah blah"
I gather my numbers for "Yes" with this expression:
- CfsQ1_Yes: Switch(tbl_Data!CfsQ1="Yes",1,tbl_Data!CfsQ1="No",0,tbl_Data!CfsQ1="N/A",0)
My numbers for No/na are gathered together as "opportunities" and here is that expression.
- CfsQ1_Ops: Switch(tbl_Data!CfsQ1="Yes",1,tbl_Data!CfsQ1="No",1,tbl_Data!CfsQ1="N/A",0)
Then I have 2 respective queries to take the Sums and finally a query that out puts my final %. My final query that outputs my % looks like this.
- CfsQ1: FormatPercent(qry_SumOfQ_Yes_Count!SumOfCfsQ1_Yes/qry_SumOfQ_Ops_Count!SumOfCfsQ1_Ops,2)
Soooooooooo.....in a nutshell. 2 qrys to turn my yes/no/na's to numbers. 2 qrys to add them. one qry to output my %. If you're tracking so far, my question is. Why won't my report run with a N/A as a selection? It works perfectly with yes/no in the table. As soon as the n/a is saved in the table....it hacks up.
Thank you graciously