Turning Row information into field headings

[Drenda]

Hello

Is there any way I can use details in a row of a table to make field headings. For example, if I have a table with 1 column (with field heading building) that looks like this
building
a
b
c
d
Can I then create a table that converts a b c d to field headings of the new table so the field headings become
a b c d
I suppose it is the reverse of a union query

Many thanks

 

[Remou]

Do you mean a crosstab query?

 

[Drenda]

Gee - thanks for the quick response

Its sort of a cross tab query but I have tried a crosstab query and the value figure seems to want to be a total or count or sum and so on and I don't realy want this

 

[Drenda]

I have just tried a cross tab query again and I think it can work

Many thanks