Using both AND OR on the query

[rjlorenzo]

Good Day,

I'm trying to display record using a query below.

if sagent = "CARE" AND FDATE <>"" AND TDATE <>"" then

SQL = "SELECT * FROM WEB_PRODUCTIVITYDONE WHERE PROD_USER ='lckatigbak' OR PROD_USER ='jbmarquez' AND PROD_ENTERED BETWEEN #" & fdate & "# and #" & tdate & "#;"

end if

What i'm trying to do is when i select CARE and enter FROM DATE and TO DATE is should display all the record that the user is under "lckatigbak " and jbmarquez" and between from date and to date.
Base on the query above it just display the all the record under those agent regardless of date.
The question is, It is possible to use OR AND at the same time on the query. is there any other way i could do it.

thank you in advance.
RJ Lorenzo

[JamieHowarth0]

Hi there,

Firstly, please use [ code] and [/ code] tags around your code.

Second you could try using an IN clause:

if sagent = "CARE" AND FDATE <>"" AND TDATE <>"" then
 
SQL = "SELECT * FROM WEB_PRODUCTIVITYDONE WHERE PROD_USER IN ('lckatigbak','jbmarquez') AND PROD_ENTERED BETWEEN #" & fdate & "# and #" & tdate & "#;"
 
end if

Hope this helps.

codegecko

[iam_clint]

you can use parands to separate these things...

where (blah = blah or blah = 2 or blah = 3) and (cat=1 or cat=2)

SQL = "SELECT * FROM WEB_PRODUCTIVITYDONE WHERE (PROD_USER ='lckatigbak' OR PROD_USER ='jbmarquez') AND (PROD_ENTERED BETWEEN #" & fdate & "# and #" & tdate & "#);"