SQL syntax Question

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

Guest

Hi-

I need assistance in proper syntax, could you please review the following
SQL statments: Please advise. I know i am getting errors on the #1. #2 May be
ok. This is for a project at work that is due very soon.

1
FormatNumber(IIF(((GetTableBasedItem(1)<0.60),(GetTableBasedItem(1)-0.43)*5500/100)),(IIF((GetTableBasedItem(1)>=0.60),((0.60-0.43)*5500/100)),IIF((GetTableBasedItem(1)<=0.43),0))),0)

2
IIF((GetTableBasedItem(1)<0.60,'Case1',IIF((GetTableBasedItem(1)>=0.60),'Case2',IIF(GetTableBasedItem(1)<=0.43),'Case3',0)))
 
PERHAPS

FormatNumber:

IIF(GetTableBasedItem(1)<=0.43,0,
IIF(GetTableBasedItem(1)<0.60, GetTableBasedItem(1)-0.43)*5500/100),
IIF(GetTableBasedItem(1)>=0.60,(0.60-0.43)*5500/100, 0)))


Case 3 is never going to be true since .43 is less than .6 which is case
1 So your second expression should probably be


IIF(GetTableBasedItem(1)<=0.43),'Case3',
IIF(GetTableBasedItem(1)<0.60,'Case1',
IIF(GetTableBasedItem(1)>=0.60),'Case2',0)))
 
Back
Top