Need a query that show results with criteria

[rehanemis]

Hi Professionals,

I have a table which contains 10,000 records. Table fields are StudentID, StudentName, Services.

In Services Field i have about 30 type of services like, Easy Rule, HomeBased, Virtuallay etc.(there are about 30 similar type of services).

I would like to get the StudentID , StudentName and Services WHERE Services <>(not equal) to Easy Rule, Home Based, Virtually etc upto 30 services.

Actually some staff entered services in bad format like they entered ER instead of Easy Rule, and Virt instead of Virtually and some staff entered Easy R and so on.

I have used Query Design View and using Expression builders but it is now allowing me to write more conditions there(I think it is limited to no of text/criteria).

Any other solution of this type of problem.

Thanks and waiting of your answer.

 

[CJ_London]

try

SELECT *
FROM myTable
WHERE Services not in ('Easy Rule', 'Home Based', 'Virtually',....)

 

[rehanemis]

Thanks, its working fine.

Just more thing. How can i check if a field contains length of <10 characters(would like to take the records where length is <10).

 

[CJ_London]

change this bit to

 WHERE Services not in ('Easy Rule', 'Home Based', 'Virtually',....)  AND len(Services)<10

 

[rehanemis]

Thanks a lot.