Text Box with Pass/Fail result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a scorecard that when the calculations are made, should return "Pass"
or "Fail"... what is best method for this?
 
You could use an update query if the calculations are to be done one mass,
or if the pass/fail result need sto be displayed on a form or on a report
you just have to set an unbound control to represent the value you want:
ie: =iif([the_checked_field] < 50, "Fail","Pass")

You could also make this a public function : (this is probably the wrong
syntax, but should work) :

function pass_fail(score) as string

if score < 50 then
pass_fail = "Fail"
else
pass_fail = "Pass"
end if

end function

The enter into the record source property of a form control, report control
or update to cell of the data grid in an update query :
=pass_fail([the_checked_field])

Hope this helps, please don't yell too loudly if it doesn;t - maybe someone
could embelish the code a bit to make it betterer. :-)

Cheers,

Craig Smith
 
Back
Top