MORE THAN 16 Fields in a QUERY (is it possible) ???

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

After much work....and much great help from this board, all things are coming
together.

BUT....now... the one "GRAND QUERY" that actually brings it all together
seems to not allow more than 16 fields to be referenced.

I have a report that gets it's data from that one final query (that brings
together multiple other queries....with relationships between fields, etc)

However, it can't display all the needed data b/c of the source query's 16
field limit.

Do I have a setting off somewhere, or is this a limitation with Access?

Any help greatly appreciated.

Thanks
 
There most certainly isn't a 16 field limit. The limit is 255 fields.

I think you're going to have to explain a little more what you're doing.
 
kev100 via AccessMonster.com said:
After much work....and much great help from this board, all things are coming
together.

BUT....now... the one "GRAND QUERY" that actually brings it all together
seems to not allow more than 16 fields to be referenced.
Click to expand...

That is how many columns show in the query design grid by default. Just use
Insert - Columns on the menu bar to insert more. Or you can just drag your
fields down from the tables/queries in the top of the designer and it will
create the columns for you automatically.

The actual "hard" limit is 255.
 
Or you can just drag your fields down from the tables/queries in the top of the designer and it will create the columns for you automatically.

Thanks very much.....that worked great.
 
Back
Top