Calculated Field Problem

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

I have a form called RiskTools that I enter a series (20
different scores) at time of service initiation and again
at service completion. My fields look like: a)test1(in)
b) test 1(out) so on and so on for 20 questions. I have
then created a calculated box on my form that uses the
formula [test 1(out)]-[test 1(in)]. This will give me the
difference. The problem is, not all tests are completed
at "out" level. I have a check box called Incomplete that
users check if the client has no outcome tests. How do I
incorporate this into the calculation? Basically what I
want it to do is to first check and see if this box has
been checked, if not, perform the calculation. If the box
is checked as incomplete, do not perform the calculation
at all. Any ideas? I am a newbie using Access 97 fyi.
Thanks so much for your help.
 
Try using:

iif([Incomplete1]=true,Null,[test 1(out)]-[test 1(in)])

but check the field name for incomplete, as I had to
guess at it.

-Ted Allen
 
Back
Top