Need to show all sold product codes in a query! Need help!

[thesaifeye]

Generally in our store one customer buy several products with different product code and quantity. I used a different table for for calculating the total pricing of a purchase and sum it to another table.
I want to show all purchased product codes in query now! But cannot manage to build the function or expression for it!



If anybody helps me with it, I will be very grateful.
Thanks

[ranman256]

all codes should be in the tOrderDetails table ,

select tOrderDetails.Code, Sum(tOrderDetails.Qty) from tOrderDetails

[ssanfu]

Welcome to the forum....


Not real clear on what you are trying to do.

I want to show all purchased product codes in query now!

By customer?
Over a date range?

Maybe examples of raw data and what you want to see....


It would be helpful to see a picture of the relationship window. (or a copy of your dB with just a few records)
Not sure why you are "summing to a different table"?? The total can be calculated at any time.

I would think you would have tables:
Customers
Products
Orders
OrderDetails.

[orange]

Here's a link to a free, generic data model dealing with Customers and Orders from Barry Williams site. It might give you some ideas on table structures and relationships.
Note; that this is a generic model dealing with typical "things" involved in Customers and Orders, but you may not need all tables for your situation.