Union Query too many fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 15 May 2005 04:41 GMT

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?

Reply to this Message

Donna - 15 May 2005 04:46 GMT

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

> 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?

Reply to this Message

Duane Hookom - 15 May 2005 04:55 GMT

Try using
UNION ALL
rather than UNION.

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

Signature

Duane Hookom
MS Access MVP

>I have 131 fields in each query that is used in the UNION
>
[quoted text clipped - 3 lines]
>> be
>> in a union query?

Reply to this Message

Donna - 15 May 2005 05:08 GMT

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
[quoted text clipped - 9 lines]
> >> be
> >> in a union query?

Reply to this Message

Duane Hookom - 15 May 2005 05:26 GMT

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

Signature

Duane Hookom
MS Access MVP

> yes, I know it's a bit excessive, but this person wants a "flat" file,
> with
[quoted text clipped - 25 lines]
>> >> be
>> >> in a union query?

Reply to this Message