Combine an "AND" and "OR" satement in vba query.

darnnnel

I have a a statement as follows:
I would like to add an "AND" criteria of "WHERE QueryCases.Completed = False"

How do i combine the two?

Dec 13 '07 #1

Dan2kx

jst a guess

Dec 13 '07 #2

ADezii

I have a a statement as follows:

sSQL = "SELECT * FROM QueryCases WHERE Weekday(QueryCases.StartDate) = 1 OR Weekday(QueryCases.StartDate) = 7 ORDER BY QueryCases.StartDate;"

I would like to add an "AND" criteria of "WHERE QueryCases.Completed = False"

How do i combine the two?

Dec 14 '07 #3

darnnnel

Worked like a charm. Thanks

Dec 14 '07 #4