Hi,
Can any one help of this please?
I have a fairly complex query (Q1) which outputs a calculated value from a table. To make it easier to understand, the calculation estimates the middle point between two dots in a scatter plot. To run this query, it asks for a 2 manual input values, say a and b, for the position of the two dots. These input values are within the formula in this query.
I have another query (Q2) which produces a and b for about 10000 different people. The row is people. a and b are two columns in this query.
My problem is: How do I produce a query/table which had the Q1 outputs for the 10000 people in Q2?
Can any one help of this please?
I have a fairly complex query (Q1) which outputs a calculated value from a table. To make it easier to understand, the calculation estimates the middle point between two dots in a scatter plot. To run this query, it asks for a 2 manual input values, say a and b, for the position of the two dots. These input values are within the formula in this query.
I have another query (Q2) which produces a and b for about 10000 different people. The row is people. a and b are two columns in this query.
My problem is: How do I produce a query/table which had the Q1 outputs for the 10000 people in Q2?