Help With Sum in Query

[jw195]

I am building a database to track and balance incoming and outgoing orders of crops.

I have 3 tables right now.

"Products" is a list of products in the database

"Incoming_Orders" is a list of incoming orders with the following fields;

"Order#", "Supplier", "Order_Date", "Ship_Date"

"Incoming_Order_Information" contains the details of each order with the following fields;

"Order#" (linked to "Order#" in "Incoming_Orders"), "Crop_Description" (Linked to "Crop_Description", the only field in the "Products" Table) and "Quantity_Ordered")

One crop may be ordered multiple times on different orders and from different suppliers, I want to see the total amount ordered for each crop across all orders.

I think the next step is to use a query that will consolidate the orders to show the quantities ordered for each crop, however I am not sure how to achieve this or if it's even the correct way to go about it.

Thanks.

 

[June7]

That would be an aggregate (GROUP BY) query.

Or build a report and use its Sorting & Grouping features with aggregate calcs in group section. Report allows display of raw data as well as summary info.

 

[plog]

Yes, a simple aggregate query:

https://support.office.com/en-us/ar...-a-query-b84cdfd8-07ba-49a7-b067-e1024ccfcca8