pivot - pivoting large table in MS Access

Question

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

question from:https://stackoverflow.com/questions/65598421/pivoting-large-table-in-ms-access

Answer 1

Waitting for answers