Need a query in VBA with AND's and OR's mixed together.

[TrevorThielen]

Good day,



I'm trying to write and sql string that essentially needs to work like this: WHERE a>b AND ((c AND d) or (e AND f))

Of course, Access 2010 doesn't like brackets in that sort of thing and I am not very experienced with SQL.

Can anyone help explain what I need to do for this? It would be greatly appreciated.

[Bob Fitz]

WHERE a>b AND ((c AND d) or (e AND f))

Not sure I understand the requirement.
Are the variables numeric?
Do you mean that either b+c+d or b+e+f are greater than a

[TrevorThielen]

Sorry, I was trying to keep it simple. a,b,c,d,e and f are all different statements.

The actual line so far is : Where ShiftStart > " & todayvar & "AND Isnull(FlightSConf) AND FlightStart < " & dateVar & " OR IsNull(FlightEConf) AND FlightEnd < " & dateVar

Only I need to be able to group them like above.

[June7]

Use parentheses to manage the hierarchy of operations.

Maybe you want:

" WHERE ShiftStart > #" & todayvar & "# AND IsNull(FlightSConf) AND (FlightStart < #" & dateVar & "# OR FlightEnd < #" & dateVar & "#)"

Note the # for delimiting date parameters.

[TrevorThielen]

Thanks everyone for the help. Turns out if you put the brackets on the inside of the "", you don't get that Expected: whatever Error!

Final working answer: ShiftStart > " & todayvar & " And ((Isnull(FlightSConf) and FlightStart < " & dateVar & ") or (IsNull(FlightEConf) and FlightEnd < " & dateVar & "))"

Have a nice day! Thanks again!