Union Query



I have a union query with (3) SELECT statements. Each SELECT statement has
87 columns. When running the query, I am getting an error message - to many
fields defined. Evidently MS-Access counts each column in each SELECT
statement and it sums to 261 fields (more than the 255 limit).

Is this normal and can you suggest a work around, other than running each
SELECT statement separately and appending the records to a temp table?



John Spencer MVP

I think you are stuck with your proposed solution.

Although you might TRY a union query with just the first 2 SELECT statements.
And then use that union query in another Union query with the third SELECT
Statement. I don't know if this will work or not. If you do try this and it
does work please post back to let us know.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question