IIF statement HELP needed

R

Robert Molina

I need to create a report

[Text1Qty] [Text2Qty] [Text3Qty]

The three quantities will vary, but i need to display the text box
with the lowest quantity only....
Thanks.
 
K

Ken Snell

Try this:

=IIf([Text1Qty] <= [Text2Qty] , IIf( [Text1Qty] <= [Text3Qty], [Text1Qty],
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]), [Text3Qty]),
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]))
 
K

Ken Snell

Sorry, I think I have a typo in the original post. Try this instead:

=IIf([Text1Qty] <= [Text2Qty] , IIf([Text1Qty] <= [Text3Qty], [Text1Qty],
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty])),
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty])
--

Ken Snell
http://www.accessmvp.com/KDSnell/




Ken Snell said:
Try this:

=IIf([Text1Qty] <= [Text2Qty] , IIf( [Text1Qty] <= [Text3Qty], [Text1Qty],
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]), [Text3Qty]),
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]))

--

Ken Snell
http://www.accessmvp.com/KDSnell/



Robert Molina said:
I need to create a report

[Text1Qty] [Text2Qty] [Text3Qty]

The three quantities will vary, but i need to display the text box
with the lowest quantity only....
Thanks.
 

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

Top