SQL Query

[Jaykappy]

I have the below code that is running a query. IT WORKS great...I have to modify it an confused on the syntax...
I need to add another varRequestType...

So the query will read: WHERE varStatus = Planned AND varREquestType1 = Web REquestor OR varRequestType2 = Mobile

Dim varRequestType1, varRequestType2, varStatus
varRequestType1 = "Web Requestor"
varRequestType2 = "Mobile"
varStatus = "Planned"
Dim myConn, Recordset,SQLQuery

SQLQuery = "SELECT * FROM MainGeneral WHERE Requestor = '" & varRequestType1 & "' AND Status = '" & varStatus & "' "


???? Do I need () to encapsulate the OR statement from the AND Statement

SQLQuery = "SELECT * FROM MainGeneral WHERE Status = '" & varStatus & "' AND Requestor = '" & varRequestType1 & "' OR Requestor = '" & varRequestType2 & "' "

[Jaykappy]

This worked

SQLQuery = "SELECT * FROM MainGeneral WHERE Status = '" & varStatus & "' AND Requestor = '" & varRequestType1 & "' OR Requestor = '" & varRequestType2 & "' "

[June7]

Do you need some parens in there like:

SQLQuery = "SELECT * FROM MainGeneral WHERE Status = '" & varStatus & "' AND (Requestor = '" & varRequestType1 & "' OR Requestor = '" & varRequestType2 & "')"