Creating OR, AND query in access and getting parametrs frm access

[HelpNeeded]

Hi All,
I am trying to get 7 parameters from access form (textboxes). I have a table
called review. I am trying to generate and predefined query. which will show
all the records from the table, whereever it finds any of the 7 words
(parameters) in any of the fields in the table. The table has 7 fields. User
would enter 7 words in any order. on Click on search, the query should search
the first field for any of the 7 words OR 2nd field with any of the 7 words
or 3rd field and so on. The query should do OR operation in each field, AND
operation when combining the fields.
for ex: user enter "I am a new user". The query should show all the records,
wherevr if finds any of the enter word, like "I" or "am" or "a" or "new" or
"user". Please help. I am new to access. Thanks.

 

[pietlinden]

Hi All,
I am trying to get 7 parameters from access form (textboxes). I have a table
called review. I am trying to generate and predefined query. which will show
all the records from the table, whereever it finds any of the 7 words
(parameters) in any of the fields in the table. The table has 7 fields. User
would enter 7 words in any order. on Click on search, the query should search
the first field for any of the 7 words  OR 2nd field with any of the 7 words
or 3rd field and so on. The query should do OR operation in each field, AND
operation when combining the fields.
for ex: user enter "I am a new user". The query should show all the records,
wherevr if finds any of the enter word, like "I" or "am" or "a" or "new" or
"user". Please help. I am new to access. Thanks.

Yikes. You're looking in 7 columns for the same value? Why? Sounds
like a normalization issue.

 

[HelpNeeded]

Hi, thanks for replying. Yes, I am searching for same value in 7 cols. User
would enter 7 words, each wordscould be present in any of the cols in any
order, I want to display the records where any of the records (Field)
contains any of the value entered by user.
Thanks.