How to add weights for related records in a query?

[wchelly]

Is there a way to add weights for related records in a query?

I have

Shipmenttbl
Shipment #

Materialstbl
Material
Truck1 Weight
Truck2 Weight
Truck3 Weight


I'd like to have

Shipment# Total Weight


Is there a way to do this in a query?

 

[wchelly]

Nevermind, I figure it out....

SELECT [Material_Description(x)].ShipperID, Sum([Material_Description(x)].[Weight_1]) AS SumOfWeight_1 INTO Current_Shipments
FROM [Material_Description(x)]
GROUP BY [Material_Description(x)].ShipperID;