Hi there, and thanks for taking the time to read this.

I have an access database which keeps market transactions.

"description" - what type of transaction is it, e.g. 'Sales'

"Type" - What the name of the item is, e.g. 'Co-Processor', 'hea
sink'

"Quantity" - how many items sold per transaction

I'd like to get a list of all types of items which have 'Sales' in te
description, and how many items per type.

So 'Co-Processor' only shows up in one row, and in the cell next to i
is the total quantity for all the 'Co-Processor' types in th
transaction database, and 'heat sink' shows up in the next row with it
total items, and so on.

What's the easiest way to do this?

K

--
Message posted from http://www.ExcelForum.com