Query across multiple field for same instance.

[Taki186]

I'm currently building a database to log computer hardware and software info.

I need to be able to design a query that will look across 10 different software fieleds, for, let say the word "Photoshop",
but I'm struggerling to understand the correct expression to use and where to use it.

I've been trying to get this working for 3 days now, I'm new to Access 2002 and I'm sure this is easily acheived. Any help
would be greatfully recieved. In the meantime, I'm gonna keep on battling on.

Thanks in advance.

Confused from London.

 

[tomschafer]

Try this....

select
*
from
TableName
where
Field1="Photoshop" or
Field2="Photoshop" or
Field3="Photoshop" or
Field4="Photoshop" or
Field5="Photoshop" or
Field6="Photoshop" or
Field7="Photoshop" or
Field8="Photoshop" or
Field9="Photoshop" or
Field10="Photoshop"