heathdotnet
Last Activity: Jun 21 '10, 03:55 PM
Joined: May 28 '10
Location: Charlotte, NC
-
Geeeeeeeeze.... ...I can't believe I missed this. I had a stray field in my last qry that produced my percentages with an expression not pointing to anything. I must have gotten in a rush doing this. That you so much for your time Sir, it is greatly appreciated!... -
All of my yes/no/na are combo boxes and are set as "text" in the data field. Right now I am retracing my steps to see if I left anything out or possibly have a wondering char. somewhere. I've went back in to previous db's that use the same priciple to see if I have slipped up somewhere. Only conclusion thus far is my n/a's aren't poducing a 0 somewhere and it's kicking back as Null...Leave a comment:
-
The yes/no/na are a drop down menu. And yes it is intentional that way it can do the math when the yes and the ops are calculated. I've narrowed it down to my final query though. All my other querys work out fine with the n/a value.
Here is my code again for the final query.
Can't pinpoint why my troubles are....Code:CfsQ1: FormatPercent(qry_SumOfQ_Yes_Count!SumOfCfsQ1_Yes/qry_SumOfQ_Ops_Count!SumOfCfsQ1_Ops,2)
Leave a comment:
-
The expression is typed incorrectly.
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...bla h blah blah"
I gather my numbers for "Yes" with this expression:...
No activity results to display
Leave a comment: