Hi,
:banghead: I have a database with two tables structured as in attachement. In a nutshell I have a list of values with two criteria associated in one table and a second table with a 3-rd criteria. What I need is to have a query with a list of values (corresponding to Criteria 1=yes) if Criteria 3 is on "Yes", and with another list of values (corresponding to Crirteria 2=yes) if Criteria 3 is on "No". Can this be solved only in one query? Please advice. Thank you.
:banghead: I have a database with two tables structured as in attachement. In a nutshell I have a list of values with two criteria associated in one table and a second table with a 3-rd criteria. What I need is to have a query with a list of values (corresponding to Criteria 1=yes) if Criteria 3 is on "Yes", and with another list of values (corresponding to Crirteria 2=yes) if Criteria 3 is on "No". Can this be solved only in one query? Please advice. Thank you.