Validating a resultant number against a number

Hi everybody.

I em making a purchase order fomrat with the capability of a Kanban supply
system, and I need the customer to order no more than the specified pallets
of product.

I have several columns where the customer will enter the amount of pallets
neded for each product, and then at the end the format will sum all the
pallets, but I need a function so that when the customer enter the amounts
and the sum of the pallets in the bottom, passes the specification, a message
error pops up to indicates the client that he had passed the limit of pallets
to order.
I tried the "Validation" function in the Data menu, but it does not
recognizes the sum as a whole number.

I hope you can help me
--
Kind Regards

Pablo Fernandez

Is it possible that your sum looks to be say 7, but is really 6.9?
--
HTH,
Barb Reinhardt



"Pablo Fernandez" wrote:

Hi everybody.

I em making a purchase order fomrat with the capability of a Kanban supply
system, and I need the customer to order no more than the specified pallets
of product.

I have several columns where the customer will enter the amount of pallets
neded for each product, and then at the end the format will sum all the
pallets, but I need a function so that when the customer enter the amounts
and the sum of the pallets in the bottom, passes the specification, a message
error pops up to indicates the client that he had passed the limit of pallets
to order.
I tried the "Validation" function in the Data menu, but it does not
recognizes the sum as a whole number.

I hope you can help me
--
Kind Regards

Pablo Fernandez

Thanks barb for your interest in helping me.

If I have a result in the sum of the columns, it should no be greater than
say 30 pallets, so if the customer is entering data and after enetering 30
pallets he wants to enter another pallet (31) then an error messaje will let
him know that he is exceeding the specified amount which is 30,
--
Kind Regards

Pablo Fernandez


"Barb Reinhardt" wrote:

Is it possible that your sum looks to be say 7, but is really 6.9?
--
HTH,
Barb Reinhardt



"Pablo Fernandez" wrote:

Hi everybody.

I em making a purchase order fomrat with the capability of a Kanban supply
system, and I need the customer to order no more than the specified pallets
of product.

I have several columns where the customer will enter the amount of pallets
neded for each product, and then at the end the format will sum all the
pallets, but I need a function so that when the customer enter the amounts
and the sum of the pallets in the bottom, passes the specification, a message
error pops up to indicates the client that he had passed the limit of pallets
to order.
I tried the "Validation" function in the Data menu, but it does not
recognizes the sum as a whole number.

I hope you can help me
--
Kind Regards

Pablo Fernandez