query too complex when transposing

  • Thread starter Thread starter Mary Fran
  • Start date Start date
M

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.
 
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.
 
I would need to see your query, sample data, and what you want the layout to
look like as the result.
 
Back
Top