search for a word anywhere in the table with certain criteria then display some info about that

[barcoen]

Hi there I wonder if someone could help me,
I have a table of information in Access and I was wondering what would be the best way to get the info I need out of it.
for example can I search for a specific word that could be anywhere in the table in any of the cells.


The word is 'pump' and I would also want to know if it is an inception pump or not and then I would like to see a list of clauses associated with the pump (the clauses would be in a specific colomn under a heading) how would I best go about searching this information please?
Thanks in advance for any help

[ranman256]

Make a form to do the search and a box for the word.
Build a query for each field you need to search.
Q1, select * from table where [fld1] like *" & forms!frmFind!txtWord & "*"
Q2, select * from table where [fld2] like *" & forms!frmFind!txtWord & "*"
Etc

make a macro that opens all these qrys.
openquery Q1
Openquery Q2
etc

Button on the form will run the macro.

[JoeM]

If you honestly need to search across multiple fields instead of just one field, that is a good indication that you have a database design issues, and your data tables are not normalized. Working with non-normalized databases can be a real pain in the neck.

If you have any control over it, you may want to re-design your tables.
Here is an article which can help in that endeavor: https://support.office.com/en-us/art...rs=en-US&ad=US