How to show row values as column values in access

Hello Good Morning

All,






Could you please help

with this

I have a

table with following two columns

TechName Version

SQLServer 2000

SQLServer 2003

SQLServer 2005

SQLServer 2008

SQLServer 2008R2

Oracle 11G

MSOffice 2000

MSOffice 2003

MSOffice 2007

MSOffice 2010



How can i show this data

as components eqch version for a techname to be one component order need not follow

TechName Component1 Component2 Component3 Component4 Component5

SqlServer 2000 2003 2005 2008 2008R2

Oralce 11G NULL NULL NULL NULL

MSOffice 2000 2003 2007 2010 NULL




Please Help me

with this

Thank you

in Advance

Asita

How to show row values as column values in access