Too many fields defined error

[Jon123]

I know that the cap is 255 fields in a query. Is there anyway around this?

 

[namliam]

For the love of queries, more than 255 fields in a single query?

No way around it that I know off....
Perhaps if you store the results in a table and update it? But I believe a table has the same limit?

 

[Jon123]

Fair enough I get it. Yes the tables have the same limits. What I'm trying to do is build a checklist that service people follow doing a task. I'm using the tabular form which is really nice and works great. So I have a 10 page tabular form with lets say 256 fields spreed out into 3 seperate tables. The problem comes in when I go to open the form and in the control source of that form I have my query that has 256 fields and it does not like it. Is there another way to open the form without using a query or can I break up the query as I did the tables?

 

[namliam]

The point of the query is that you need the columns in the same place isnt it?

If you have 10 pages you can cut the query into 10 pages as well, needs some micro managing but feasable. Having that many columns though, OUCH

 

[Jon123]

That might work. A pain to setup but once set its done.

jon