"Too many Fields" error running query with <255 fields

[ian.davies52]

I'm having a problem running a query. I get the "too many fields" error
message, but I only have 162 fields in the query and I thought the
limit was 255. The problem query (Query1) is based on query2 that pulls
together records from two tables. Could the problem be that some of the
fields in Query1 use expressions using (SELECT "[field1]",
"query2","[field2]>3")? The rest of the fields in Query1 just use Avg.

Thanks in advance,
Ian

[Allen Browne]

As well as the 255-field limit, there's another limit in Access. All the
fields need to fit into the buffer size, which is around 2000 characters.

Memo fields contribute only about 10 characters for the address, so
replacing some of the wide text fields with memos might be a workaround.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ia**********@btopenworld.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I'm having a problem running a query. I get the "too many fields" error
message, but I only have 162 fields in the query and I thought the
limit was 255. The problem query (Query1) is based on query2 that pulls
together records from two tables. Could the problem be that some of the
fields in Query1 use expressions using (SELECT "[field1]",
"query2","[field2]>3")? The rest of the fields in Query1 just use Avg.

Thanks in advance,
Ian