If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating OR, AND query in access and getting parametrs frm access
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. |
#2
|
|||
|
|||
Creating OR, AND query in access and getting parametrs frm access
On Jul 12, 12:50*pm, HelpNeeded
wrote: 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. |
#3
|
|||
|
|||
Creating OR, AND query in access and getting parametrs frm acc
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. " wrote: On Jul 12, 12:50 pm, HelpNeeded wrote: 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. |
Thread Tools | |
Display Modes | |
|
|