I'd like to pivot a table, similar in structure to the one below:
To display as follows:
The actual table I'm using has over 1.6 million rows, and 1500+ different field values (field 1, field 2, field 3, etc) currently in the Field column. The goal is to pivot the contents to make the table less unwieldy to work with. The Field_Answers
are mostly of the Long-Text
data type, which seems to be a problem, as I am getting the error:
"Cannot have Memo or OLE Object fields in aggregate argument"
I'm currently trying to use the query below, which returns the above-stated error:
TRANSFORM Max(mytable.FieldAnswer)
SELECT mytable.ID
FROM mytable
GROUP BY mytable.ID
PIVOT mytable.Field
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…