make table query

[Guest]

I have three tables I would like to merge into one. I've used the make-table
query function but am getting a "too many fields defined" message. help!

 

[Rick Brandt]

I have three tables I would like to merge into one. I've used the
make-table query function but am getting a "too many fields defined"
message. help!

There are limits to the number of fields in a table or query (255) and there is
a limit to the total bytes in any given row of a table. If you are exceeding
either of these then there is not much you can do about it except to make
modifictions that bring your result in under the limit.

It is generally excepted that approaching anywhere near either of these limits
is a pretty good indicator of poor design. Properly normalized tables would
seldom exceed 50 or 60 fields.