Display two different strings in Calculated Field based on rhe value in another field

A

Adrian

Hi,

How do i write/create my query in such a way that the calulated field
"Type" will display either "Young" or "Old" based on the value of "Age" in
the table "Members"? if the Age field is more than 50, the calculated field
will display "Old", otherwise "Young".

Thanks.
 
M

Michael Keating

Hi,

You can do this by typing

Age Status:IIf(Age>50, "Old", "Young")

into the "Field:" row in the query designer.

MFK.
 
Top