M MarkP Registered User. Local time Today, 22:54 Joined Jun 13, 2003 Messages 15 Jul 24, 2003 #1 How can I use iif not in an access query. IIf (fsubject not = to ssubject ,do this) Is equal is easy enough but I'm not sure what character I use for not.
How can I use iif not in an access query. IIf (fsubject not = to ssubject ,do this) Is equal is easy enough but I'm not sure what character I use for not.
Fizzio Chief Torturer Local time Today, 22:54 Joined Feb 21, 2002 Messages 1,885 Jul 24, 2003 #2 IIf (fsubject <> ssubject ,this if true, this if false) I'm assuming that fsubject and ssubject are fields in your query.
IIf (fsubject <> ssubject ,this if true, this if false) I'm assuming that fsubject and ssubject are fields in your query.
