IIF statement HELP needed

  • Thread starter Thread starter Robert Molina
  • Start date Start date
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.
 
Try this:

=IIf([Text1Qty] <= [Text2Qty] , IIf( [Text1Qty] <= [Text3Qty], [Text1Qty],
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]), [Text3Qty]),
IIf([Text2Qty] <= [Text3Qty], [Text2Qty], [Text3Qty]))
 
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.
Click to expand...
Click to expand...
 
Back
Top