using sum and iif

F

Floyd Forbes

How do I write an expression using sum iif ?
I'm trying to sum Ten textboxes in one textbox base on IIF a value
is greater or less than in one of the Ten textboxes.

Floyd
 
C

Col

Try

Sum(IIF(textbox1>somevalue,textbox1,0)+IIF(textbox2>somevalue,textbox2,0)+IIF(textboxn>somevalue,textboxn,0))

Col
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function in textbox 0
Access My Expression Contains Wrong number of arguments 0
Sum(iif(...)) Help 8
Summing a complex formula 1
#name? error 5
Aggregate Function Error 0
Printing iif results in a report 3
Sum Iff Function 8

Top