multiple possibilities for a field in access

When I do a search for the field major (ex. Computer Science), there is one person in my database who has Computer Science and Spanish in the major category. After completing the search, how do I make it so the code will show her name as well (if there are two or more possibilities in a field), since she would match the computer science search. Here is my code:

SELECT * FROM ALUMNA
WHERE 0=0
<cfif Len(Form.maj)>AND MAJOR='#Form.maj#'</cfif>

Thanks a bunch!

SELECT lastname FROM ALUMNA
WHERE 0=0
<cfif Len(Form.maj)>AND MAJOR='#Form.maj#'</cfif>

This is really, really basic SQL by the way. If these sorts of issues are hampering you, then you *really* need to get a SQL book.

I am guessing here, but what i think you are asking is how do you have this person show up for both CS and Spanish search? If that is the case, it is another simple SQL change. Instead of using =, use the like command and surround your searching value with wildcards (oracle would be: MAJOR LIKE '%CS%')

Thanks EBOT!!! Have an awesome weekend!