MS-Access Query variable name from value in a different query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You lost me but based on the jist of what you are saying do this.

In your 2nd query in design view put your data table and 1st query.
Pull down the fields you need from the table. Pull down the results from
1st query you want to use as criteria into the Field row of the grid. Copy
the field and paste as criteria.
 
Back
Top