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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling of null return in number field on form? 4
Display Time based on another field value 2
Error in Creating Calculated Field 1
Calculate field with input from different table 5
Populate field based on If statement 5
Access MSACCESS - Sorting report based on field calculated in the report 0
Hide Error in Calculated Age Field when no DOB entered? 4
Default Value as last date in a table? 5

Top