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

  • Thread starter Thread starter Adrian
  • Start date Start date
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.
 
Hi,

You can do this by typing

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

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

MFK.
 
Back
Top