Search Button

[Coldsteel]

Hi,

Does anyone have any examples of how to do a search for any part in Access. I would like to be able to search for the word APPLE and get the data with any fields with the word APPLE.
Example: Search: APPLE
Result: apple, apple pie, apple color

Thanks,
Mike

 

[rommelgenlight]

if you pertain to search record in your table, you can make a query our of your tables you want to search and put in the criteria the expression:

Like "*" & [] Or Like [] & "*"

where [] will be the value you want to search.

 

[HiTechCoach]

Mike,

Check out really cool search tool: Universal Search on many text with details

Hope thios helps ...