query criteria

[awake2424]

In an Access 2010 query is it possible to set a criteria on a field (Results), that If it is "Negative" then another field (Variants) has the text "None Detected". Or is it easier to do that in the Variants field? Thank you.

 

[pr2-eugin]

Do it in the Variants field.. Something like..

VariantFieldName: IIF(Result < 0, "None Detected", "Whatever")