How to show row values as column values in access

[Asita]

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

 

[plog]

This is called a cross-tab query in Access:

https://support.office.com/en-us/ar...cc8-ba60-2cd8484667e8?ui=en-US&rs=en-US&ad=US

 

[Asita]

Hi Could you please help me with query as I am very new to this cross I tried design wizard I don't need any summary so I stucked here.,

please....

 

[plog]

Where exactly are you having trouble? What did you try?

 

[RainLover]

Depending on the proposed outcome from this Database maybe we could look at deNormalising. As in turn thing around in the actual table. This is merely a suggestion. It may not fit in with the objectives.