return a message to a text box based on a calculation

[Guest]

I have a scorecard that performs calculations. Based on these calculations,
I need to return either "passed" or "failed" to a text box. This form will
be printed. What is the best method of doing this? Should I perform the
calculation in the properties of the text box? Should I perform the
calculations in a query?

 

[John Nurick]

You can do either, though where possible I prefer to do it in the query.
For example, a calculated field might look like this, first checking
that all the data is available and then testing the result of the
calculation:

PassFail: IIf([F1] Is Null Or [F2] Is Null Or [F3] Is Null,"Missing
data",IIf([F1]+[F2]+[F3]>50,"Passed","Failed"))