Need help with a report expression

[Rustyone]

It has been awhile since I worked in access.



Text24 and Text 35 are a number.

The first part(IIf) of this works. My problem is the second part(IIf) does not work. What am I doing wrong?


=IIf([Text24]>11,[Text35]+500,IIf([Text24]>15,[Text35]+750))

[pbaldy]

Logic problem. If a value is greater than 15, it's also greater than 11. Access uses the first true expression.

[Rustyone]

Logic problem. If a value is greater than 15, it's also greater than 11. Access uses the first true expression.

so would this work?

=IIf([Text24]>11<15,[Text35]+500,IIf([Text24]>15,[Text35]+750))

[Rustyone]

I am try to get this to recalculate at each level cumulatively 12 =500, 16=250, 20=250, 24=250, 28=250

12 =500
16= 750
20=1000

Etc.Etc

[pbaldy]

No, that wouldn't work. You'd test for greater than 15, then greater than 11. In other words highest to lowest. With that many, I'd use the Switch() function or a custom function, or put the values in a table.