Combine like product fields in table and total quantity for those like fields

[GodivaGirl]

Good morning,



I have a product table that includes the name of the product, the quantity ordered, and the unit price. This is a summary table for the whole year showing all of the orders. The Primary Key is [ID] from the [tblOrders] table. I attached a screen shot of my query. I don't know if you can see it. I want to generate a report where each product is listed once, the unit price for that product is listed, the total number of that item that was ordered throughout the year, and finally, the total amount spent for each item during the year.

Thank you.

[orange]

What you have described as a Product Table would typically be called
OrderLineItem or OrderDetail. You haven't really described your database in business terms, but i think a 4-5 line overview (the 30000 ft level) in plain English would be helpful.

Often, when you see a "Order and Product" type database, you would have

Customers, Orders, OrderDetail, Product tables.

Here is a free, generic data model for example. It is generic in that it shows tables and relationships for a typical set up. However, your details may be different and all tables/fields may/may not be appropriate.

[GodivaGirl]

Thank you very much. I have it fixed now.