How to convert record row values into column values

[shalskedar]

In the Ms Access 2003 database,in 1 of the Reports I need to display the records in the form of columns..


For ex-If the values are

Elu
Ela
Res

then this data is to be displayed as

Elu Ela Res

Can anyone Plz help me with this..

[yarbrough40]

I think you want a cross tab query

[Mr Key]

You may also Create Customized label of your own design