I'm using a union query to get the top 20 values of 5 criteria. There are 104 columns in the result. I'm now getting this errror after building 3 of the required 5 criteria.
Any way around this?
Too many fields defined. (Error 3190)
You tried to perform an operation that involves more than 255 fields. Reduce the number of fields, and then try the operation again.
Any way around this?
Too many fields defined. (Error 3190)
You tried to perform an operation that involves more than 255 fields. Reduce the number of fields, and then try the operation again.