Using a Quantity on a Form to Calculate Totals

[slayeratcp]

Hi Guys,

I have a table with SKUs listed, their volumes, and their weights. I'd like to use a form to select a group of SKUs that make up an order, enter a quantity, and then have the total order weight and volume (by SKU) listed in a query. Any suggestions?

Basically, I'd like to create a way to calculate order weight and volume for shipment planning purposes.

Thank you

[June7]

Build a report with a RecordSource that joins tables (Products and OrderDetails).