Expressions for calculating Text fields

[drnld]

Hello,



I am trying to create an expression that determined by text fields. The field is a PASS for FAIL field. The result needs to =PASS if 70% of the total column is PASS.

Any ideas? Can this even be done using an expression?

Dottie

[amrut]

You can try the IIF function iif ( condition, value_if_true, value_if_false )
See here for more http://www.techonthenet.com/access/f...vanced/iif.php

[burrina]

Here is a Demo that will hopefully help you.

[drnld]

Thank you for your prompt reply. So would I need to create 2 columns for results? I need to find out the total number of PASS in the column to make sure 70% of them are PASS. This number may vary depending on the number of skills attempted.

I guess I'm not sure what to put for the condition.

Dottie

[burrina]

You are asking what the percentage of this is from that! 2 variables. Then if that percentage is 70, then somefield = PASS.
Correct?
In the below example, c would equal the percentage,txtpassfail is the display field.

If c >= 70 Then
Me.txtpassfail = "PASS"
Else
Me.txtpassfail = "FAIL"
End If

HTH