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

darnnnel

I have a a statement as follows:

Expand|Select|Wrap|Line Numbers

 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?

Dan2kx

Expand|Select|Wrap|Line Numbers

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

jst a guess

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?

Expand|Select|Wrap|Line Numbers

 sSQL = "SELECT * FROM QueryCases WHERE 

Weekday(QueryCases.StartDate) In ("1","7") AND QueryCases.Completed = False ORDER BY QueryCases.StartDate;"

darnnnel

Worked like a charm. Thanks

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

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ