I got a report that list all of the product received. It has the following fields
order_no
description
prod_weight
qty_received
qty_order
recv_weight (qty_received * prod_weight)
charges (recv_weight * 6.4998 / 100)
We have a minimum charge of .65. I need to set the charges field in the report to reflect this, so if
charges < .65 then make it .65
charges >= .65 then do nothing
charges = 0 (did not received) then leave at 0
I'm new to VBA but can manage
Thanks in advance for any help with this
RJL1
order_no
description
prod_weight
qty_received
qty_order
recv_weight (qty_received * prod_weight)
charges (recv_weight * 6.4998 / 100)
We have a minimum charge of .65. I need to set the charges field in the report to reflect this, so if
charges < .65 then make it .65
charges >= .65 then do nothing
charges = 0 (did not received) then leave at 0
I'm new to VBA but can manage
Thanks in advance for any help with this
RJL1