J
James D. Houston
I work for a small mail order company and I'm trying to get a estimate of
our shipping costs. If we get a order for 6 items and we only have 4 in
stock, we will ship the 4 and backorder the other 2. The table structure
looks like this: Order#, Weight, ShipDate, Cost. I need a query that will
tell me the total shippng cost for each order. I other words, if we have
two shipments for Order# 40314 and the first shipment cost 6.95 and the
second cost 5.95 I want a query where the results look like this:
Order # Cost
40314 12.90
Thanks in advance
Jim
our shipping costs. If we get a order for 6 items and we only have 4 in
stock, we will ship the 4 and backorder the other 2. The table structure
looks like this: Order#, Weight, ShipDate, Cost. I need a query that will
tell me the total shippng cost for each order. I other words, if we have
two shipments for Order# 40314 and the first shipment cost 6.95 and the
second cost 5.95 I want a query where the results look like this:
Order # Cost
40314 12.90
Thanks in advance
Jim