Crosstab Queries

[jex57]

Hi
I have a table that has data as follows:

(column name and table name)

I am trying to create a crosstab query which will give me the results that look as follows:

Any suggestions on how to do this?
Thank you

 

[xenou]

Hi, I don't think this can be done with a crosstab query.

 

[ranman256]

a crosstab need 3 values so you cant, but a report could do it on your table.

group on Col.Name field, then show table.names
but set the report in PAGE SETUP to print N columns,
Left-Right THEN Top-Down.


not perfect, but it will work.