Developer Forum

I need to show two or three value in Cross Tab Query. But
it only allows one value. (with command Transform.... Then
pivot).


Can anybody help to advise?

Dear CC:

You cannot show more than one value at each "intersection" when you
use a Cross Tab. But there is a standard way of coding a query that
gives you crosstab like results that does not have this limitation.

This is done by having a subquery for each cross-product column.

If you do not know how to do this, I suggest that a complete course of
how to do it is not within the scope of newsgroup assistance.
However, if you can completely describe the source tables or queries
and give details of the data that will be encountered and the kind of
results you need, I can try to craft the query you need.

Do the number of columns vary with the data? Do the column headings
need to vary with the data? If so, how do you want the columns
labelled?

The process of learning what you want may take a few posts before I
can start.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Thu, 1 Jan 2004 19:11:38 -0800, "cc"