J
Jim
I have access 2003 with a query to fill in a bill of lading that shows the
shipping weight and freight class for our products. The report then totals
the weight for the entire shipment, adding in the weight of a pallet based
on the number of pallets entered as a parameter. Since there can be two
separate freight classes on the same report, I need to add the weight of the
pallet to the lowest class so the totals add up. Right now what I'm getting
is:
Product 1 @ 30# Class #55
Product 2 @ 30# Class #85
Pallet(s) = 1 @ 45#
Total Weight 105#
What I need is:
Product 1 @ 30# Class #55 + Pallet(s)
Product 2 @ 30# Class #85
Total Weight 105#
Thanks for any help
Jim
shipping weight and freight class for our products. The report then totals
the weight for the entire shipment, adding in the weight of a pallet based
on the number of pallets entered as a parameter. Since there can be two
separate freight classes on the same report, I need to add the weight of the
pallet to the lowest class so the totals add up. Right now what I'm getting
is:
Product 1 @ 30# Class #55
Product 2 @ 30# Class #85
Pallet(s) = 1 @ 45#
Total Weight 105#
What I need is:
Product 1 @ 30# Class #55 + Pallet(s)
Product 2 @ 30# Class #85
Total Weight 105#
Thanks for any help
Jim