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