ACCESS 2016, too many fields defined error

Anonymous
2015-12-29T01:14:32+00:00

My query give me an error TO MANY FIELDS DEFINED. When i count the fields i have only used 226.

What is causing this?

Thanks for any help

ed

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-12-22T00:15:56+00:00

Not without using subreports because once tied together they will be over 255.

Side note:  Sounds like the person who advised you is using far less of the data in the tables than you, is that so?

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-05T00:47:27+00:00

Not into word into the window on the web page in the link I posted.

Hmm, yep you need to bring it into a clean one again.  Note, what you downloaded was probably flat file format which means that is the way they display it not store it.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-04T21:51:05+00:00

Passing on secret tip....

To format queries for easier reading, go to...

https://sqlformat.org/

Just copy in the SQL and click the Format SQL button.  (Really wish that was built into Access!)

No problem glad to help.  And hopefully, this post never disappears!

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2016-01-07T22:57:03+00:00

No problem... will get a message even if you reply 10 years from now! :)

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2015-12-29T01:41:09+00:00

Hmm, could be one of those deceptive messages because there is also a 1.024 character limit and spaces count!

That said, a query with that many fields is the *real* concern.  It sounds like an UN-normalized structure.  Why so many fields in the query?

Was this answer helpful?

1 person found this answer helpful.
0 comments

64 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2017-12-21T23:18:56+00:00

    Ni Gina

    I realize my program  even though it works now is a disaster and maybe in the future it wont work. So i have no alternative buy to change or quit.

    A man from our organization has offered to help. Here is what he suggested.You need to really think about learning VBA so you can convert all these iif's to logic in VBA

    I import 3 htr exports, but I don't join anything. I have a main table I call HX4 in my db and during my import process (or procedure as access calls it) I append only the data I really want to see or use. So all of the data I want to see or use is in a single table.

    For example I have 229 fields from HTR exports 13 fields that I have defined for my own calculated data and 14 spare fields in case Ken comes up with something else.If Kens adds new stuff I either use the spares or just eliminate old fields that I don't really use.

    here is the approach I use

    1. import all of the htr export files into a tables.
    2. in a VBA module append only the data I use into a single table
    3. do all of my personal calculations and put the results in my own fields.

    Now I have a single table with all of the data I want use and see and I have queries on this table that I use for handicapping.

    the benefits of this approach

    a single table no joining (faster db)

    all of your iff logic done once at input time in vba and the results put in the main table for your use (no running complex queries that have to do all that logic every time you want to see something.

    My question is Gina I now have two queries [which consist of many tables and queries] that are used in my report. Someone showed me how to link them so i could put one above the other jn my current report. If i have him show me how to make two tables because one table will only allow 255 fields and i need more fields than that. These tables will contain my IIF statements in VBA format plus field data. Once this is done can i somehow tie my two tables together and put them in my report one above the other?   Sure hope you say yes.

    Thanks for helping Gina

    ed

    Was this answer helpful?

    0 comments