Recent content by OlBill

Understood. Maybe I can post a sample tomorrow. The one I'm working with has sensitive data in it. Thank you for your time. No doubt @Pat Hartman is absolutely correct about the field. Maybe I can figure out a way to change BRL to a number.

Got it. Thanks @Gasman . I put your code in my immediate window. What do I do now?

I put <=Sum(IIf(Val([LeadResult])>0.05,1,0))> in the Control Source for the text box and <?"BRL">"0.05"> in the Immediate Box in the VBA Editor. "Data type mismatch in criteria expression"

0.05 is the threshhold for positive results. Anything below 0.05, including BRL, is negative.

Ok, I'm in the VBA and see the immediate window. I put the < ?"BRL">"0.05"> in the immediate window? and the whole statement goes where?

Thanks Pat. "BRL" is a result, just like 0.012 or 10.2. I understand what you are saying, but I can't choose the reporting criteria, I am at the mercy of the system. My reporting has to match the values sent by other people. I definitely have a text value in the mix.

=Val([LeadResult])>0.05 Gives me "#Type!"

Thank you Minty. I don't know what the immediate window is.

I am trying to get the total of the red boxes.

Below Readable Limit. I'm trying to count just what is above 0.05. BRL is below 0.05.

It is text. Did it with the quotes, =Sum(IIf([LeadResult]>"0.05",1,0)) It is counting the BRLs.

Data Type mismatch in criteria expression

If by string you mean the field in that table, because of the BRL.

Thanks @Gasman, I have no idea where or how to do that.

Thanks Pat. I got this "Data Type Mismatch in criteria expression"