G
gwiegel
I have two queries.
One has the customer name and their values on questions 1 thru 5.
fields cust_num, q1, q2, q3, q4, q5
The other has the question number and value for the question number.
fields quest_no, quest_value
The second query prompts you for the quest_no
I want to use the results from the second query to select which value I want
in the first query.
That way if I run query 2 and enter 'q5' for at the prompt I get
'q5', 'What is your name' as a result
I then want to get the all customer names and their value for q5 from the
first query
In one query 'q5' is a value in the other 'q5' is a variable.
Any ideas?
Thank you
One has the customer name and their values on questions 1 thru 5.
fields cust_num, q1, q2, q3, q4, q5
The other has the question number and value for the question number.
fields quest_no, quest_value
The second query prompts you for the quest_no
I want to use the results from the second query to select which value I want
in the first query.
That way if I run query 2 and enter 'q5' for at the prompt I get
'q5', 'What is your name' as a result
I then want to get the all customer names and their value for q5 from the
first query
In one query 'q5' is a value in the other 'q5' is a variable.
Any ideas?
Thank you