Hello
Firstly, apologies for creating yet another thread regarding a search form - you'll be happy to know the majority of my setup is already complete!
I have created a search function for an internal knowledgebase ran via Access - at present the criteria parameter for my query is
This currently works absolutely fine, however if somebody searched a two word criteria such as 'Access help' for example, it would search for the string 'Access help' whereas I would like the query to search for 'Access "*" help' therefore returning any results that contain the words access or help.
Any advice would be greatly appreciated - my attempts have failed thus far, as has my googling...
Many thanks.
Firstly, apologies for creating yet another thread regarding a search form - you'll be happy to know the majority of my setup is already complete!
I have created a search function for an internal knowledgebase ran via Access - at present the criteria parameter for my query is
Code:
Like "*" & [Forms]![Navigation Form]![NavigationSubform]![NavigationSubForm]![KnowledgebaseSearch]![SearchKeyword] & "*"This currently works absolutely fine, however if somebody searched a two word criteria such as 'Access help' for example, it would search for the string 'Access help' whereas I would like the query to search for 'Access "*" help' therefore returning any results that contain the words access or help.
Any advice would be greatly appreciated - my attempts have failed thus far, as has my googling...
Many thanks.
