I have a query which has 8 criteria fields, meaning that I will need 128 grid rows to build complete conditions with OR and AND functions to cover all the possible conditions from the selection criteria fields.
How many query grid rows I can use without exceeding the maximum rows. I have tried with 6 fields (32 rows), it gives me "Query too complex", run-time error 3360 as result.
How can I do this? Thanks.
How many query grid rows I can use without exceeding the maximum rows. I have tried with 6 fields (32 rows), it gives me "Query too complex", run-time error 3360 as result.
How can I do this? Thanks.