query too complex when transposing

[Mary Fran]

I have a query which produces 18 calculated fields which I am trying to
transpose using "select ID, first field" UNION "select ID, second field",
etc., and by the 4th UNION I get the "query too complex" message. Is there
any other way to transpose query data or what else can I do? Thanks.

 

[Mary Fran]

Unless someone has a better way, I ended up doing a make-table query and then
used that as the datasource for the UNION queries and it worked - not ideal
but functional.

 

[KARL DEWEY]

I would need to see your query, sample data, and what you want the layout to
look like as the result.