8 reputation
2
bio website
location
age
visits member for 1 year, 11 months
seen Mar 4 '13 at 9:28

Dec
26
awarded  Student
Dec
25
awarded  Scholar
Dec
25
accepted Pivot a table to repeat the first column for each following column
Dec
25
comment Pivot a table to repeat the first column for each following column
That indeed seems to be the opposite of what I'm trying to do. ( Same for Crosstab ) I should be able to do what I need to do with the union all and hope that they move the data to a SQL DB soon :)
Dec
25
comment Pivot a table to repeat the first column for each following column
Thanks for the info! Looking from the examples this looks very promising :) My only concern is with the "generic" query because this would become a really big one depending on the amount of columns. I have read something about a "Transform" function which would be similar to Pivot, do you happen to have knowledge of this for Access?
Dec
25
asked Pivot a table to repeat the first column for each following column