cross table problem

[humanmaycry]

I right now have a big issue which torch me for days.


I have a table like this
name course1 course2 course3
Chris 1 1 0
Patti 0 1 1
Alice 0 0 1

I want to have a result like:
Name CourseChosen
Chris course1
Chris course2
Patti course2
Patti course3
Alice course3

How could I do this? please help!
the number in the original table, 1 represents chosen and 0 represents non-chose.
Thanks for help!
Regards

[pbaldy]

Try a UNION query:

SELECT Name, "Course1" AS CourseChosen
FROM TableName
WHERE Course1 = 1
UNION ALL
SELECT Name, "Course2" AS CourseChosen
FROM TableName
WHERE Course2 = 1
UNION ALL
...

[humanmaycry]

Thanks Pbaldy.
Actually, I have tried this and it works. However the issue is, I have about 200 courses.
I heard SQL has a function called " unpivot"
it seems much easier, however I don't know if it support Access 2007

[pbaldy]

Sorry, I'm not familiar with a function like that (which doesn't mean it doesn't exist).