Union Query - Too Many Fields

  • Thread starter Thread starter byeo
  • Start date Start date
B

byeo

I have 4 identical tables with 224 fields each and want to run a union query
on them to get all records but when I run I get the message stating 'Too many
fields defined'. Clicking help, it says "You tried to perform an operation
that involves more than 255 fields." Is my query not formatted correctly or
will it not let me do this? In my mind the operation I'm trying to perform
involves 224 fields...

Thanks,
Bob.
select * from [ITEM_TEMPLATE_BUILD - 1MFG]
union all select * from [ITEM_TEMPLATE_BUILD - 2RAW]
union all select * from [ITEM_TEMPLATE_BUILD - 3PKG]
union all select * from [ITEM_TEMPLATE_BUILD - 4SFG];
 
The limit in access is 255 fields. When you union 2 tables with 224 fields
access sees that as 448 fields. You might try an update or append query if
you need to update information from one table to another.
 
Thanks - that's what I suspected but thought I would check. I'll use the
append query.

Golfinray said:
The limit in access is 255 fields. When you union 2 tables with 224 fields
access sees that as 448 fields. You might try an update or append query if
you need to update information from one table to another.

byeo said:
I have 4 identical tables with 224 fields each and want to run a union query
on them to get all records but when I run I get the message stating 'Too many
fields defined'. Clicking help, it says "You tried to perform an operation
that involves more than 255 fields." Is my query not formatted correctly or
will it not let me do this? In my mind the operation I'm trying to perform
involves 224 fields...

Thanks,
Bob.
select * from [ITEM_TEMPLATE_BUILD - 1MFG]
union all select * from [ITEM_TEMPLATE_BUILD - 2RAW]
union all select * from [ITEM_TEMPLATE_BUILD - 3PKG]
union all select * from [ITEM_TEMPLATE_BUILD - 4SFG];
Click to expand...
Click to expand...
 
I have 4 identical tables with 224 fields each and want to run a union query
on them to get all records but when I run I get the message stating 'Too many
fields defined'. Clicking help, it says "You tried to perform an operation
that involves more than 255 fields." Is my query not formatted correctly or
will it not let me do this? In my mind the operation I'm trying to perform
involves 224 fields...

Thanks,
Bob.
select * from [ITEM_TEMPLATE_BUILD - 1MFG]
union all select * from [ITEM_TEMPLATE_BUILD - 2RAW]
union all select * from [ITEM_TEMPLATE_BUILD - 3PKG]
union all select * from [ITEM_TEMPLATE_BUILD - 4SFG];
Click to expand...

As Golfinray says, the problem is... 672 fields.

224 fields is about 200 too many for any properly designed table!! I strongly
suspect you're "committing spreadsheet" - any way that these monsters could be
normalized?
 
Back
Top