Forum Discussion
Solved
Query is "Too Complex" Need help with alternate coding.
I got an error message that the query was “Too Complex”. When I entered the code for column 68, I got the error message, “The query is too complex”. I need help with coding to avoid the problem. ...
- it is best to Create a Temp table with that number of Columns and save your calculation result to the table. note however that you cannot have More than 255 columns in ms access.
use VBA to calculate and save the result to the table.
you can open a Form (datasheet) and on the Open/Load event clear the temp table first, calculate and append the result to the table.
it is best to Create a Temp table with that number of Columns and save your calculation result to the table. note however that you cannot have More than 255 columns in ms access.
use VBA to calculate and save the result to the table.
you can open a Form (datasheet) and on the Open/Load event clear the temp table first, calculate and append the result to the table.
use VBA to calculate and save the result to the table.
you can open a Form (datasheet) and on the Open/Load event clear the temp table first, calculate and append the result to the table.
- Hi arnel_gp. Thanks for responding to my questions. I have the logic down. I will have to freshen up on my VBA. Then I will try to implement.
