IIF numbers to the right of a Decimal ...

[Smilie]

I am trying to create a report that has the number of cases and loose cans that a customer orders. The number is stored as quantity ordered (qtyord). It will tell me that the customer has ordered 1.25 cases and each case has 24 cans on it. I want my report to say that they need 1 case and 6 cans (24*0.25).

Anyone out there no how to do this???? I am on a very short deadline, so the sooner the better.

THANKS!!!

 

[pbaldy]

You could use Int(qtyord) to capture the full cases, and qtyord - Int(qtyord) to get the partial case.

 

[Smilie]

THANK YOU!!!!!!! It worked like a charm. It's always these little things that get me.