"IN" Clause

I'm developing an ASP app where a user can choose from several categories (selecting multiple), and display results of records that contain these categories. Each Record has the fields Category1, Category2, Category3, Category4. I created a script to parse the selected categories, and include them with an "IN" clause in the SQL query (using ACESS 2000 database). Here is an example:

Select * From [Members] where (category1 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category2 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category3 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations')) or (category4 IN ('Photography/Video',' E-Learning',' PR/Marketing/Media Relations'));

when I select more than 1 Category, not all records appear. For instance, in the above statement, all records with "E-Learning" as one of the categories do not appear in the recordset. Perhaps there is a better way of writing the SQL statement that I am not aware of.