need to return Pass or Fail to text box or label

  • Thread starter Thread starter Guest
  • Start date Start date
Dtoney,

One good method is to use a calculated field in a query, or an
expression as the control souce of an unbound textbox on a form or
report. It could be applicable for such an expression to use the
Switch() function or the IIf() function.

If you need more specific help with this, please post back with some
more details, with examples, of what you are trying to achieve.
 
For a checkbox, bind it to a calculated field that returns -1 (True) for
a pass and 0 (False) for a fail.
 
I work with Analysts that fill out scorecards for CSRs and grade them on 3
sections... one is strictly pass/fail based on a question they must ask. The
other 2 sections are scored by weighted averages. They must achieve 97% or
they fail... thus the pass/fail message. Typically, the form is printed and
sent to the managers... my thoughts were to produce a report... but I'm the
new kid and don't want to "change" stuff right away! I'm also a newbie to
Access... studied it briefly in school... but this is different for sure!
 
Dtoney,

You are correct that a report for sending to the managers would probably
be preferable to printing the form.

As for the pass/fail, I imagine an unbound textbox on the form/report,
with its Control Source property set to an expression which works out
the pass or fail result based on the other values on the form.
 
Back
Top