Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 ACCESS Query

Author  Topic 

dmadhavi
Starting Member

4 Posts

Posted - 2012-03-24 : 21:55:22
Hello,

I have a delima, and im not really sure if this possible. But i have a table like lets say

studID ACDlevel MAJOR age gender
1 GR PHY 40 M
1 UG CHEM 40 M
1 DC PHY 40 M
2 GR CPSC 28 M
3 GR CPSC 50 F
3 UG HRDA 50 F

and now I want a able like

sudID ACDlevel_1 ACDlevel_2 ACDlevel_3 MAJOR_1 MAJOR_2 age gender

1 GR UG DC PHY CHEM 40 M
2 GR CPSC 28 M
3 GR UG CPSC HRDA 50 F

can anyone help me out...:)


madhavi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-24 : 22:07:27
see

http://allenbrowne.com/ser-67.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -