October 8, 2003 at 1:48 pm
HEre is the data i have,i wanted to represent this data in the format shown in the second table
name name name name subject marks marks marksmarks
john bill will steve subject110 20 3040
john bill will steve subject211 21 31 41
john bill will steve subject3 12 22 32 42
john bill will steve subject4 13 23 33 43
This is the format of data i have.
I would like to represent this data as
name subject1 subject2 subject3 subject4
john 10 111213
bill 20212223
will 30313233
steve 40414243
How can i format my data into this desired format.
Thanks.
October 8, 2003 at 3:26 pm
What you need to do is called a "Pivot Table Query"(in Access it is called a Cross Tab Query). If you look in Books Online for "Cross Tab Reports" you should get a pretty good example of what you want.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply