Competent Performer
Windows XP 
Access 2010 32bit
My error message is the "wrong number of arguements".
I am trying to create a new column with two criteria being met.
1) The column "Activity Type-SA not equal to "Travel"
and
2) The column "Rate Value = "1".
FaceTime: ((IIf([ACTIVITY TYPE-SA]<>"Travel") AND ([RATE VALUE] ="1")),[TIME-SA],"0")
Attached is a screen print.
Thanks for help formatting this one.
Russ
Competent Performer
Windows XP Access 2002 (version 10.0)
The expression should be :-
Code:FaceTime: IIf(([ACTIVITY TYPE-SA]<>"Travel") AND ([RATE VALUE] ="1"),[TIME-SA],"0")
Competent Performer
Windows XP Access 2010 32bit
That works! Thanks Russ
Competent Performer
Windows XP Access 2002 (version 10.0)
Glad to see your posting back with success!
If your issue is resolved, may you use this forum's thread tools feature to mark it solved.
Simple Expression
Iff Statement Meeting 2 Conditions
Posting Permissions
Reply With Quote