How to fix "has a function containing the wrong number of arguments" error?

iif( [POSITION]= "ADD NEW POSITION","OR","DELETE POSITION"=NO.OF POSITIONS INCREASE,"OR","NO.OF POSITIONS AT LEAST"

HELP ME PLEASE

Feb 18 '16 #1

Subscribe Post Reply

✓ answered by jimatqsi

This call is malformed. Where is the closing parenthesis? It's hard to tell what you're trying to say or do here.

The correct format of that call is
iif(test,true result,false result)
so

Expand|Select|Wrap|Line Numbers

 iif([Position]="Add New Position" or [Position]="Delete Position",[No Of Positions Increase],[No of Positions at least])
 
 

something like that. You give so little information that it's nearly impossible help you.

2406

jimatqsi

1,271

Expert 1GB

This call is malformed. Where is the closing parenthesis? It's hard to tell what you're trying to say or do here.

The correct format of that call is
iif(test,true result,false result)
so

Expand|Select|Wrap|Line Numbers

 iif([Position]="Add New Position" or [Position]="Delete Position",[No Of Positions Increase],[No of Positions at least])
 
 

something like that. You give so little information that it's nearly impossible help you.

Feb 18 '16 #2

KHALID115

thanks jimatqsi

i have 2 tables

first table :
1- name
2- position
3-nationality
4-visa No.

second table :
1-position
2- No of visas .
3- No of used visas .
4- No of remaining visas .

but I want to use iif function when add new position in first table increases the no of used visas in the second table automatically
pls help me .

Feb 20 '16 #3

by: News Central | last post by:

To all! I use the DateDiff function using VB6 and get this error 'Wrong number of argument or invalid property assignment' ... have anyone seen this problem? thanks ....

Visual Basic 4 / 5 / 6

PLS-00306: wrong number or types of arguments in call

by: Pial | last post by:

Hi : I am using Asp.Net, C#, Oracle . I am trying to execute this Stored Procedure, and it gives me an error "Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of...

.NET Framework

How do fix: "Wrong number of arguments" / "invalid propert assignment"/ "Invalid argument"

by: Java Guy | last post by:

I'm trying to view a web page. IE tells me there are (Java?) errors on the page. Here they are: Line: 15 Char: 7 Error: Wrong number of arguments or invalid propert assignment Code: 0 URL:...

Javascript

Oracle Wrong number or types of arguments error

by: dmjpro | last post by:

this is my funciton block in oracle ....... Function PIM_TEST ( param1 IN DATE DEFAULT SYSDATE, param2 IN OUT DATE) RETURN DATE IS -- -- To modify this template, edit file...

Java

XSL, XML...count function returns wrong number sometimes

by: emorrison | last post by:

I hope this isn't too vague, but I have a large XML file and when I try to use a count function in an XSL file to get the number of nodes, it returns 0 for a particular node. I can correctly count...

XML

Expression has wrong number of arguments

by: tinareed | last post by:

Please help out a newbie. I've copied a complicated query and am trying to modify it for mailing labels. First, last name and primary address are the fields. Primary address would be either a home...

Microsoft Access / VBA

Wrong number of arguments or invalid property assignment

by: vunet | last post by:

Hello, I've just installed ASPXMLRPC library and testing their main function: xmlRPC ("URL", "command_name", params) The function converts all parameters to XML, sends a request to third-...

ASP / Active Server Pages

Primary Key error wrong number of qualifiers

by: sachin | last post by:

Hi, I am facing some strange issue in DB2 UDB 9.5.1 I have created a database on DPF implemented environment and I tried to execute following commands Db2 create table test ( name char(10)...