Creating an SQL query with AND and Or clauses.

[Johanb26]

Good day

Can somebody please assist me I have the following query:

WHERE client_division = 'DivisionA' OR client_division = 'DivisionB' OR client_division ='DivisionC' and results_date >= #01/01/2014#;

What I want the query to return is only the selected divisions and their results from 01/01/2014 and upwards. But with my query as above I get all the selected divisions and the date is ignored, so the query displays results from 2013 and back.

Please help me.

[CJ_London]

try putting the 'OR' part of your query in brackets

WHERE (client_division = 'DivisionA' OR client_division = 'DivisionB' OR client_division ='DivisionC') and results_date >= #01/01/2014#

you can also write it this way

WHERE client_division  IN ('DivisionA', 'DivisionB' , 'DivisionC') and results_date >= #01/01/2014#

[Johanb26]

Thank YOU!!!

It worked and the IN clause is a wonderful piece of advice