Union Query too many fields

[Guest]

I created a union query using Select * from each query. When I run it I get
an error message that says too many fields definded. How many fields can be
in a union query?

 

[Guest]

I have 131 fields in each query that is used in the UNION

 

[Duane Hookom]

Try using
UNION ALL
rather than UNION.

131 fields sounds like a bit much. I assume you have your tables as needed.

 

[Guest]

yes, I know it's a bit excessive, but this person wants a "flat" file, with
all data available for all students for all years - contains pre & post test
scores for about 60 different areas of testing.

Anyway, I'm not sure what you mean by UNION ALL - this is what I have:

SELECT *
FROM [2-98-99AllPrePost1]
UNION SELECT *
FROM [2-98-99AllPrePost2];

 

[Duane Hookom]

SELECT *
FROM [2-98-99AllPrePost1]
UNION ALL
SELECT *
FROM [2-98-99AllPrePost2];

--
Duane Hookom
MS Access MVP

yes, I know it's a bit excessive, but this person wants a "flat" file,
with
all data available for all students for all years - contains pre & post
test
scores for about 60 different areas of testing.

Anyway, I'm not sure what you mean by UNION ALL - this is what I have:

SELECT *
FROM [2-98-99AllPrePost1]
UNION SELECT *
FROM [2-98-99AllPrePost2];

Try using
UNION ALL
rather than UNION.

131 fields sounds like a bit much. I assume you have your tables as
needed.