Row to Querie

[Guest]

Dear All,

I need a Query where i have to change Row-Field to a Column Field as the
below Sample Data:

Existing ODBC Table:
PdmNum FabricNum CatCode CatDesc ColorCode ColorDesc01
ColorDesc02 etc.
1234567890 A 1234567890 ABCDEF 20200 310
100
1234567890 B 123456790 ABCDEF 10000 100
310

new Query:
PdmNum FabricNum CatCode CatDesc ColorCode 20200 10000 etc.
1234567890 A 1234567890 ABCDEF 20200 310 100
1234567890 B 123456790 ABCDEF 10000 100 310

Please be so kind and let me know if there is any possibility to change the
Query as above!

Thanks,
Zora

 

[Guest]

Check out Crosstab queries in Help. There's even a Crosstab Query Wizard when
you build a new query. You can build a crosstab based on your current query.

One problem that is see is the number of row headings. Crosstabs only allow
three and your example looks like 5.

 

[Guest]

"Crosstabs only allow three and your example looks like 5"

Really? Since when? I've got numerous Crosstab queries (written in XP and
2k3) that contain more than 3 "Row Heading" columns.

Dale

 

[Guest]

How?

Using Access 2003, I go to the Database Window and select Queries from the
Objects bar.

Next I go to New and select Crosstab Query Wizard from the dialog box.

I select the appropriate table or query then hit Next > .

The dialog box says:

Which field's values do you want as
row headings?

You can select up to three fields.

I attempt to add 4 Available Field to the Select Fields list, but Access
won't let me.

 

[Guest]

Jerry,

I don't use the crosstab query wizard. I guess I missed that portion of
your post that you were giving the OP instructions on using the wizard, not
on how to create the crosstab query.

Dale

 

[Guest]

But after the wizard does it's do then go to design view and add more if you
need.