Hello List,
I am trying to develop a query that populates itself with variables. I am trying to determine a start variable and an end variable with the query finding everything in between.
Example:
I will select C2:1-75 (first variable to start the query) and C2:300-500 (last variable to stop the query). I want it to find all the records that are connected; the result would be C2:75-150, C2:150-225, C2:225-300 (this is just a minor example - it could have many more results getting from the start to the finish). With the answers I would be able to find any other records that relate to these answers.
Is this possible?
Do I need to clarify further?
Thank-you in advance.
I am trying to develop a query that populates itself with variables. I am trying to determine a start variable and an end variable with the query finding everything in between.
Example:
I will select C2:1-75 (first variable to start the query) and C2:300-500 (last variable to stop the query). I want it to find all the records that are connected; the result would be C2:75-150, C2:150-225, C2:225-300 (this is just a minor example - it could have many more results getting from the start to the finish). With the answers I would be able to find any other records that relate to these answers.
Is this possible?
Do I need to clarify further?
Thank-you in advance.
