Union Query

[JimP]

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