I have created a form with 3 combo boxes (c1, c2, and c3). I create a button to activate a query to call up the records that matches the selections. Right now, in my query I create a "Or" select query where any criteria that matches with bring up the records. For example, I select c1 and c2, and all the records that have c1 OR c2 with show up.
My question is: is there a simple way to create a query that with give the following results:
select c1 & c2 from the form and give me all records that have c1 AND c2
select c1 & c2 &3 from the form and give me all records that have c1 AND c2 AND c3
but select c1 only with give me records with c1 only
select c2 only with give me records with c2 only
select c3 only with give me records with c3 only
Another word can I combine "OR" and "AND" in one single select query.
I know how I did it is stupid. Please suggest other methods.
Thank you...
My question is: is there a simple way to create a query that with give the following results:
select c1 & c2 from the form and give me all records that have c1 AND c2
select c1 & c2 &3 from the form and give me all records that have c1 AND c2 AND c3
but select c1 only with give me records with c1 only
select c2 only with give me records with c2 only
select c3 only with give me records with c3 only
Another word can I combine "OR" and "AND" in one single select query.
I know how I did it is stupid. Please suggest other methods.
Thank you...
