Text Box with Pass/Fail result

[Guest]

I have a scorecard that when the calculations are made, should return "Pass"
or "Fail"... what is best method for this?

 

[slobbering_dog]

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