Back again with a newbie question.
I have a table with three fields:
speler, jaarweek, stand
1,"2006-38", 1
1,"2006-39", 2
2,"2006-38", 2
2,"2006-39", 3
What I an trying to do is to get a query that gives me:
speler, 2006-38, 2006-39
1,1,2
2,2,3
I tried CASE, IF(), IF...THEN but no result I...