Calculate totals of seperate fields using a query

[kiza1987]

Hi ladies and gents,



Please excuse my ignorance as I've only been using Access for the last couple of weeks (trying to create a database for my customers, tired of using excel!)

I have an 'Orders' table that I use to insert data of orders with the following fields:

Item A, Item A Qty, Item A Price, Item B, Item B Qty, Item B Price, Item C, Item C Qty, Item C Price

I want a query that calculates total sales & quantity of each item that I have available. Eventually I would like to turn it into an inventory type of thing.

Thanks for any help!

Kieran.

[pbaldy]

That is not the kind of design you want for the table. Research normalization, and/or check the order details table in the Northwind sample db that comes with Access. You want a record (row) for each item sold.