=sum(iif(positi on="driver" and "labour" and "civil enginner" and "project manager" and "manager",1 ,0))
this submission is false .
What is the true submission ?
Please help me
KHALID115
Last Activity: Mar 21 '16, 10:37 AM
Joined: Feb 18 '16
Location:
-
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 . -
KHALID115 started a topic How to fix "has a function containing the wrong number of arguments" error?in AccessHow 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
No activity results to display
Leave a comment: