Filtering data out of access database
 

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

Filtering data out of access database
 

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.

--
Regards,
Tom Ogilvy

"Kashgarinn " wrote in message
...
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', 'heat
sink'

"Quantity" - how many items sold per transaction

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

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

What's the easiest way to do this?

K.


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

Filtering data out of access database
 

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

The pivotTable worked after I got the hang of it.

Thanks alot.

K

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

Filtering data out of access database
 

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

--
Regards,
Tom Ogilvy

"Kashgarinn " wrote in message
...
Thanks for your reply. I'm such a newb sometimes :)

The pivotTable worked after I got the hang of it.

Thanks alot.

K.


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