validation in the field

[Guest]

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

 

[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

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]