validation in the field

B

Bala

Hi

I would like to assign the value in to the table field as follows

Field A (Value) * Field B(Value) go to Field C

if field value of C is = < 5 then Low
if field value of C is = 5-10 then Medium
if field value of C is = 10-15 then High
if field value of C is = 15-20 then Critical

Could you please
 
J

John W. Vinson

Hi

I would like to assign the value in to the table field as follows

Field A (Value) * Field B(Value) go to Field C

if field value of C is = < 5 then Low
if field value of C is = 5-10 then Medium
if field value of C is = 10-15 then High
if field value of C is = 15-20 then Critical

Could you please
Click to expand...

This field *SHOULD NOT EXIST* in your table, if it can be reliably derived
from the value of A and B. You can calculate it on demand in a Query: in a
vacant Field cell type

Severity: Switch([A]* < 5, "Low", [A]* < 10, "Medium", [A]* < 15,
"High", [A]* < 20, "Critical", True, "HEAD FOR THE HILLS!!!")

The last option handles the case that A*B is outside any of your stated
ranges.

John W. Vinson [MVP]
 
Top