D
dtoney
I have a scorecard that when the calculations are made, should return "Pass"
or "Fail"... what is best method for this?
or "Fail"... what is best method for this?
S
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
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