UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Faulty Expression, Access 2003    
 
   
ghoti
post Oct 22 2017, 07:27 AM
Post#1



Posts: 184
Joined: 29-June 05



I am stumped with this expression: "The expression that you typed has a function containing the wrong number of arguments."
It worked until I added the first part if the expression (IIF([ID]=1 AND ....)

CODE
=IIF([ID]=1 AND IIf([Adj1]="five",1,0))


Where have I gone wrong?
Go to the top of the page
 
ghoti
post Oct 22 2017, 07:32 AM
Post#2



Posts: 184
Joined: 29-June 05



Sorry folks. I have just solved it:

CODE
=IIf([ID]=1 And [Adj1]="five",1,0)
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 10:50 AM