Search results

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"

Thank you. I tried this and it still counted the the BRLs. =Count(IIf([LeadResult]>"0.05",True) And ([LeadResult]<>"BRL"))

Good morning, I have built a text box to count based on a criteria (sum the total that meet a criteria). My data is numbers above 0.05 and below 0.05. I also have "BRL" as data. The formula I am using is "=Count(IIf([LeadResult]>"0.05",True))". It is giving me the count for the above 0.05...

I got my queries and reports working. I also built a check for duplicates query for my assets, and it's working. This is a much better set up than what I had before. Like 1,000 times better. Thank you all for your help. Thank you mike60smart, for your patience.

Sorry you misunderstood. You're latest help has got me right where I need to be with the tables and forms. It is very easy to input and see. Add asset didn't work as well as this for my process. Adding an Asset isn't hard, adding the samples is repetitive. I am sure I have set up my query...

Oh, I don't want to do that! I really like this latest set up. It's working well. I've got two Assets in there. I tried a query by AssetID. That works fine. Then I added in LeadResult and AsbestosDetected and it went crazy. Gave me back 162 results on 1 asset. I have 16 Samples with results.