Pivots and Crosstabs

S

Sa

I need someone here with a little patience and
explanation skills.
I need to explain to someone who has limited access
experience (lots of Excel thought) how to understand and
contruct Pivots and Crosstabs in Access.
At the moment they use the pivot table in Excel to
summarise date in a variety of ways, but have been
advised to import this into Access and use this package.
The sort of things they need to do is analyse the
following data:
The sort of things they need to pivot or Croostab are:

Outlets
Products
Product Range
Qty held in stock
Qty Sold
Cost of product
Etc
If anyone could perhaps point me to a site where I can
see examples that would be great.
Thanks in advance
 
T

Tom Wickerath

How's this for Crosstab Queries?

Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html


Tom
________________________________________

:

I need someone here with a little patience and
explanation skills.
I need to explain to someone who has limited access
experience (lots of Excel thought) how to understand and
contruct Pivots and Crosstabs in Access.
At the moment they use the pivot table in Excel to
summarise date in a variety of ways, but have been
advised to import this into Access and use this package.
The sort of things they need to do is analyse the
following data:
The sort of things they need to pivot or Croostab are:

Outlets
Products
Product Range
Qty held in stock
Qty Sold
Cost of product
Etc
If anyone could perhaps point me to a site where I can
see examples that would be great.
Thanks in advance
 
Top