Crosstab query to fill values in Table

[Giz]

Hi,

How can I get a Crosstab Query to fill out a Table like so:-

A B C
+----+----+----
1: 1A : 1B : 1C
2: 2A : 2B : 2C
3: 3A : 3B : 3C

The number of Rows (1,2,3...) and Columns (A,B,C...) would be taken
from another Table/Query.

TanxInAdvance

[strauss.sean]

Could you elaborate somewhat? I'm not sure what you're asking; here's
my interpretation... You say you have x rows and y columns. You want
to form a matrix, a table, that's x by y. You also want the each cell
to be a concatenation; the number of the row with the letter
corresponding to the number of the column. Is this right?

I think I could help, but I need to know if this is what you are
looking for...

Sean

[Giz]

Hi Sean,

Sorry I was a bit vague, but you pretty much understand what I'm
looking for.

I have a Crosstab Query which pulls the number of Rows and Columns from
another Table/Query, but doesn't fill in all the possible blank cells
(Excel speak) within the Table. A "matrix" is a pretty good name for
what I am looking to achieve.

Cross-referencing and combining the first Row and Column values to fill
up the Table, akin to the grid which divides up a map.

Any clearer?

[Bas Cost Budde]

Giz wrote:

Hi,

How can I get a Crosstab Query to fill out a Table like so:-

A B C
+----+----+----
1: 1A : 1B : 1C
2: 2A : 2B : 2C
3: 3A : 3B : 3C

Create a cartesian product (that is, both the column and row tables but
no joins inbetween) and base a crosstab query on that

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Giz]

Hi Bas,

Strange. The only difference between what you advised and what I did
was me taking both Row and Column information from a single
Table/Query.

It is now returning what I require.
Thanks to you.

Thanks to Sean also :-)

[Bas Cost Budde]

Giz wrote:

Hi Bas,

Strange. The only difference between what you advised and what I did
was me taking both Row and Column information from a single
Table/Query.

That is some difference indeed. You are asking, in fact, for two
independent axes of values, as if they were coordinates on a plane,
describing the whole plane. That means there must be two non-related
sources.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea