Search in 3 columns

[Rafkevs]

Hello,

I cannot find anyway to do a querry search in different columns.
For example:
a movie database, a movie has more genres, so i have a column for genre1, genre2 and genre3. now i want to be able to search in all three columns at the same time for 1 genre, is that possible ?

 

[gromit]

Hi - welcome

Sure, you can search each of the columns. When you are in the "Design View" of the query, you can enter a value for each column to search on.

Important Note: If you enter a value on the same line in design view, then the search conditions must ALL be met. E.g. if you put "Comedy" for genre1, and "Action" for genre 2, then the query will only return records where genre1 is "Comedy" AND genre2 is "Action."

On the other hand, if you put the criteria on different lines, then ANY of the conditions must be met. E.g. if "Comedy" is on one line for genre1 and "Action" is on another line for genre2, then the query will return records where EITHER genre1 is "Comedy" OR genre2 is "Action".

hth,

-g