i am having a problem with my sql statement. I am trying to show the records where the status is equal to a few things and ignore some other ones. Apparently, I am not doing the OR part correctly. I am trying to only show the records where the status is equal to those things. Any help would be appreciated.<BR><BR>sSQL= "Select * From table Where Owner = '" & rs("Owner") & "' And Status='Open' OR Status='Pending' OR Status='On Hold' Order by ID"