M
MikeHatton
I have a query which contains approximatly 200 fields, the data come
from two tables (1 to 1 relationship) each table contains 200 + fields
The query works fine, However when I use the query as the source for
report I get 'too many fields' error...
I know the limit is 255 fields in either a table or a query and bot
tables and the final query have less fields than this..
I cannot reduce the amount of data that is required, and I do no
realistically want to use dlookups for each field on the report.
Is there a simple solution or a quick fix
from two tables (1 to 1 relationship) each table contains 200 + fields
The query works fine, However when I use the query as the source for
report I get 'too many fields' error...
I know the limit is 255 fields in either a table or a query and bot
tables and the final query have less fields than this..
I cannot reduce the amount of data that is required, and I do no
realistically want to use dlookups for each field on the report.
Is there a simple solution or a quick fix