correlated subquery in the crosstab

Hi all,

After searching the net for a complete day or two, I have concluded
that the crosstab query in access has much more capablities than
expected. What I am looking for is the possiblities of putting sql
correlated subqueries in the body of the crosstab query say the
TRANSFORM clause.

And besides does anyone bother to know the dynamics of rows and columns
of the crosstab. for example is it possible to have row and column
averages.

have fun,
Hamid

.

Loading