Row to Querie

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
"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
 
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.
 
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
 
Back
Top