Query All Fields in a Table (a newbies question)

[sflem1039]

I am as new to access as one can be. I work in a small company and there is no one at my office that knows access, so I'm in this by myself.

I have a database with a table that contains 12 fields. I would like to create a query that would search every field in every record in the table by a query word or better a group of words.



If I create an additional field for "key searchable words", I can query that field with the criteria Like"*word*". But I would rather not do that but instead query the 12 fields already in the table records.

I am making a database for a small engineering company and I want to archive all the projects completed and be able to search the table by key words and retrieve the records that contain at least one of the key words.

Thanks for any help. I'm a newbie. I have an Access book on order, but it's not arrived yet.

[June7]

Sounds like table structure is not normalized.

The LIKE criteria can be under each field with OR operator.

If you need more help, provide sample of data and desired output. If you want to provide db for analysis, follow instructions at bottom of my post.

[sflem1039]

I'll educated myself on normalized table structure. Thanks,