I am using Access 97, and I need to allow my users to type in multiple keywords in a textbox and have the database, replace the comma with the word OR.
That way my SQL statement will read the textbox field and find any records in the database that have matching keywords.
Example:
user types in:
dog,cat,mouse,house
Through code it should change it to read,
*dog* or *cat* or *mouse* or *house*
If you can help please do.
That way my SQL statement will read the textbox field and find any records in the database that have matching keywords.
Example:
user types in:
dog,cat,mouse,house
Through code it should change it to read,
*dog* or *cat* or *mouse* or *house*
If you can help please do.