Automated Field

  • Thread starter Thread starter Lacybug
  • Start date Start date
L

Lacybug

I have a dB that I track wellness screening results. I want to be able to
put in a blood pressure reading and have a field populate whether it is high,
normal, etc.

I feel like this is some type of IF statement.

Can anyone help me?

Thanks much!
 
Lacybug said:
I have a dB that I track wellness screening results. I want to be able to
put in a blood pressure reading and have a field populate whether it is
high,
normal, etc.

I feel like this is some type of IF statement.

Can anyone help me?

Thanks much!
Click to expand...

I think you're right. Try an Iif in a calcuated field in a query
(untested):

Iif([BloodPressure] <a, "Low", Iif([BloodPressure] between b and c,
"Normal", Iif([BloodPressure] >c, "High")))

Keith.
www.keithwilby.co.uk
 
BTW, as you describe it, this is essentially a calculated field. You should
decide whether you want to store the result vs. not (in which case, calculate
and display it at time of use).

If the classification might be manually modified, or if you want to record
classification by the then-current standard, then you'll probably need to
store it. Otherwise you're probably better off not storing it.
 
I have a dB that I track wellness screening results. I want to be able to
put in a blood pressure reading and have a field populate whether it is high,
normal, etc.

I feel like this is some type of IF statement.

Can anyone help me?

Thanks much!
Click to expand...

I would suggest that you NOT store this field in your table, since it can and
should be calculated on the fly. If you want to do so you could create a small
table with the translation.

For blood pressure you'll presumably want to use both the systolic and
diastolic readings to determine whether there is hypertension, hypotension, or
more complex conditions. I'm not a doctor or an expert in diagnosis but this
might be more complex than it seems at first blush!
 
Back
Top