Transpose a table

[john]

Hi,

please can anyone help me with advice or best still code to transpose a
table in access.

cheers

 

[Duane Hookom]

Do you have a few sample records and how you would like them to look in the
final result? Generally this can be done with a union query followed by a
crosstab query.

 

[john]

HI Duane,

please find the current table structure below.

I would simply like to use the current rows as the future columns.

cheers

Transpose help Role Unit FS Alt MCI Group Fire-fighter (N) Fire-fighter
(W) Fire-fighter (R) Fire-fighter (C) Crew Manager (N)
FF1 Inform and educate your community to improve awareness of safety
matters FS B06

R R G
R
FF2 Take responsibility for effective performance FSB 14

R R R


FF3 Save and preserve endangered life


R R R

 

[John Vinson]

HI Duane,

please find the current table structure below.

I would simply like to use the current rows as the future columns.

cheers

Transpose help Role Unit FS Alt MCI Group Fire-fighter (N) Fire-fighter
(W) Fire-fighter (R) Fire-fighter (C) Crew Manager (N)
FF1 Inform and educate your community to improve awareness of safety
matters FS B06

R R G
R
FF2 Take responsibility for effective performance FSB 14

R R R


FF3 Save and preserve endangered life


R R R

This isn't a table, at least not recognizably one; it looks like a
word-wrapped segment of a document of some sort.

Please post a description of your table name, with its field names,
one field per row. It might help to have a description of the type of
data stored in each field.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Duane Hookom]

I don't see table and field names or data without consider effort and
guesswork. I even attempted to paste into notepad.

Could you try again to provide table and field information, samle data, and
desired results?