Access Items Generated in Matrix?

I am using a matrix in a report and it would be great to be able to work with
some of the values it is displaying after they had been grouped and split
apart.
Is it possible to access these values from the matrix somehow?i would look up actions with analysis services. this might be what you're
talking about.
OLAP (analysis services) against OWC allows a flexible, high-performance
reporting solution.
-aaron
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> I am using a matrix in a report and it would be great to be able to work
with
> some of the values it is displaying after they had been grouped and split
> apart.
> Is it possible to access these values from the matrix somehow?|||Interesting... I will look at it.
Besides this possibility, does anyone know of any other technique that might
be useful here? Is there a way to do something akin to subtotaling but
instead have it show the difference between columns?
"aaron kempf" wrote:
> i would look up actions with analysis services. this might be what you're
> talking about.
> OLAP (analysis services) against OWC allows a flexible, high-performance
> reporting solution.
> -aaron
>
> "Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
> message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> > I am using a matrix in a report and it would be great to be able to work
> with
> > some of the values it is displaying after they had been grouped and split
> > apart.
> >
> > Is it possible to access these values from the matrix somehow?
>
>

Access help.

I am a beginning programmar using Access. I need help defining creating a query that shows the number of items from a particular field as there are many of the same items. As well as create seperate listings for each item as they are also located under different location keys. Can anyone help???

This question sounds pretty basic and I feel really dumb for asking.Look at the following 2 functions: count(*) and group by

col has values 1,3,6,1,2,1,1,3

e.g. - select col, count(*) from table group by col

would return:

col count(*)
1 4
2 1
3 2
6 1|||does the same rule apply when you are trying to sort 2 columns by count.

ex.

col 1 - High School 1, high school 2 high school 3
col 2- IIe, IIe, iMac, II, HP HP, IIe, IIe, iMac, II, HP HP
col 3 - count

I am trying to create a count list for: high school 1, 2 and 3.

Jeremy

Originally posted by rnealejr
Look at the following 2 functions: count(*) and group by

col has values 1,3,6,1,2,1,1,3

e.g. - select col, count(*) from table group by col

would return:

col count(*)
1 4
2 1
3 2
6 1