Scale formula for < and > items.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Access 2003:
I need to calculate the number of Associates needed at a location based on
the number of transactions that were completed.
My query formula I am using is:
IIf([TELLERS TRANSACTIONS]<10000 / 2200 Or IIf([TELLERS TRANSACTIONS]<=15000
/ 2500 Or IIf([TELLERS TRANSACTIONS]<=20000 / 2700 Or IIf([TELLER
TRANSACTIONS]<=25000 / 2900 Or IIf([TELLER TRANSACTIONS]<=30000 / 3100))))
When I run the query it is telling me I have the wrong number of arguements.
Please help..Thank you
 
The IIf sould be

IIf(Condition , Then , Else)

Try
IIf([TELLERS TRANSACTIONS]<10000 , 2200 , IIf([TELLERS TRANSACTIONS]<=15000
, 2500 , IIf([TELLERS TRANSACTIONS]<=20000 , 2700 , IIf([TELLER
TRANSACTIONS]<=25000 , 2900 , IIf([TELLER TRANSACTIONS]<=30000 , 3100 , 0)))))
 
I must be really messing this up. I am placing this in the criteria section
of another column and placing the below information. I am asked for a value
parameter and the data is not going through the division of the transactions.
For example if I have 9000 transactions I need the query to divide that
number by 2200 to get my needed data.
I am wondering if I need a criteria for each if than statement.
TELLER STAFFING DATA: IIf([TELLERS TRANSACTIONS]<10000,2200,IIf([TELLERS
TRANSACTIONS]<=15000,2500,IIf([TELLERS TRANSACTIONS]<=20000,2700,IIf([TELLER
TRANSACTIONS]<=25000,2900,IIf([TELLER TRANSACTIONS]<=30000,3100,0)))))

Ofer Cohen said:
The IIf sould be

IIf(Condition , Then , Else)

Try
IIf([TELLERS TRANSACTIONS]<10000 , 2200 , IIf([TELLERS TRANSACTIONS]<=15000
, 2500 , IIf([TELLERS TRANSACTIONS]<=20000 , 2700 , IIf([TELLER
TRANSACTIONS]<=25000 , 2900 , IIf([TELLER TRANSACTIONS]<=30000 , 3100 , 0)))))

--
Good Luck
BS"D


tam said:
I have Access 2003:
I need to calculate the number of Associates needed at a location based on
the number of transactions that were completed.
My query formula I am using is:
IIf([TELLERS TRANSACTIONS]<10000 / 2200 Or IIf([TELLERS TRANSACTIONS]<=15000
/ 2500 Or IIf([TELLERS TRANSACTIONS]<=20000 / 2700 Or IIf([TELLER
TRANSACTIONS]<=25000 / 2900 Or IIf([TELLER TRANSACTIONS]<=30000 / 3100))))
When I run the query it is telling me I have the wrong number of arguements.
Please help..Thank you
Click to expand...
Click to expand...
 
If it's a criteria write

IIf([TELLERS TRANSACTIONS]<10000,2200,IIf([TELLERS
TRANSACTIONS]<=15000,2500,IIf([TELLERS TRANSACTIONS]<=20000,2700,IIf([TELLER
TRANSACTIONS]<=25000,2900,IIf([TELLER TRANSACTIONS]<=30000,3100,0)))))

Drop the
TELLER STAFFING DATA:
--
Good Luck
BS"D


tam said:
I must be really messing this up. I am placing this in the criteria section
of another column and placing the below information. I am asked for a value
parameter and the data is not going through the division of the transactions.
For example if I have 9000 transactions I need the query to divide that
number by 2200 to get my needed data.
I am wondering if I need a criteria for each if than statement.
TELLER STAFFING DATA: IIf([TELLERS TRANSACTIONS]<10000,2200,IIf([TELLERS
TRANSACTIONS]<=15000,2500,IIf([TELLERS TRANSACTIONS]<=20000,2700,IIf([TELLER
TRANSACTIONS]<=25000,2900,IIf([TELLER TRANSACTIONS]<=30000,3100,0)))))

Ofer Cohen said:
The IIf sould be

IIf(Condition , Then , Else)

Try
IIf([TELLERS TRANSACTIONS]<10000 , 2200 , IIf([TELLERS TRANSACTIONS]<=15000
, 2500 , IIf([TELLERS TRANSACTIONS]<=20000 , 2700 , IIf([TELLER
TRANSACTIONS]<=25000 , 2900 , IIf([TELLER TRANSACTIONS]<=30000 , 3100 , 0)))))

--
Good Luck
BS"D


tam said:
I have Access 2003:
I need to calculate the number of Associates needed at a location based on
the number of transactions that were completed.
My query formula I am using is:
IIf([TELLERS TRANSACTIONS]<10000 / 2200 Or IIf([TELLERS TRANSACTIONS]<=15000
/ 2500 Or IIf([TELLERS TRANSACTIONS]<=20000 / 2700 Or IIf([TELLER
TRANSACTIONS]<=25000 / 2900 Or IIf([TELLER TRANSACTIONS]<=30000 / 3100))))
When I run the query it is telling me I have the wrong number of arguements.
Please help..Thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top