How do I pull data from 2 tables with 255+ combined columns?

  • Thread starter Thread starter rashar via AccessMonster.com
  • Start date Start date
R

rashar via AccessMonster.com

Hello,

I have read everywhere that the maximum amount of columns that can be
returned in a query is 255. I need to be able to pull all the data from 2
tables so that I can display it on a form.

Is there any possible way to accomplish this without getting rid of any
columns? I tried to break it up into smaller queries, but that does not seem
to work. I also am unable to normalize the table, because each table will
hold slightly different information then the other table.

Thanks in advance.
 
One possibility is to use a form for 200 plus fields and a subform for
another 200 plus fields. Or to break the data up into segments that are
even smaller than that and use mulitple sub forms to display the data.

Personnally, I would hate to try to look at that many fields at one time and
locate the correct data.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I also am unable to normalize the table, because each table will
hold slightly different information then the other table.
Click to expand...

I can't buy that argument. If either table has as many as 128 fields, that's
about a hundred too many for any properly normalized database!

What are these tables, and what kind of data is in them?

John W. Vinson [MVP]
 
Back
Top