Can you Set two criteras in a Query?

[cliffsimms]

I need to set two criteras in Query. When I do it now I write the following

"Pete" "Walt"

I get a syntax error

 

[kaspi]

Try
in ("Pete", "Walt")

 

[cliffsimms]

Thanks

tried it but found out needed to write

"pete" or "walt"

thanks though