Filtering data out of access database

K

Kashgarinn

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
 
T

Tom Ogilvy

It sounds like a pivot table would be a good start.

Data=>Pivot Table Report and Chart

follow the wizard. Make sure you go into layout on the last screen and
layout out your data using the field buttons.
 
K

Kashgarinn

Thanks for your reply. I'm such a newb sometimes :)

The pivotTable worked after I got the hang of it.

Thanks alot.

K
 
T

Tom Ogilvy

It is a powerful tool. Once you get used to it, I think you will find a lot
of uses for it.
 
Top