AnsweredAssumed Answered

why this simple VB code results in an error??????

Question asked by Jamal432@gmail.com on May 23, 2011
Latest reply on May 24, 2011 by LukeW
why this simple VB code results in an error??????

please, see the attached image that shows my question

i used the code below to calcualte the value of a field, but it didn't work!!!

what's wrong with it?

if [FC_mm] <=50 then
op = 0

else
if [FC_mm]>50 and [FC_mm]<=90 then
op = 50

else
if [FC_mm] >90 and [FC_mm] <= 140 then
op = 125

else
if [FC_mm] >140 and [FC_mm] < = 200 then
op = 250

else
if [FC_mm] > 200 and [FC_mm] < = 250 then
op = 500

else
if [FC_mm] > 250 then
op = 750

end if
end if
end if
end if
end if
end if

Attachments

Outcomes