how can i create a query in Access 2016 to search out any part of an existing field for a word or phrase? The field in question is a Long Text Field.
how can i create a query in Access 2016 to search out any part of an existing field for a word or phrase? The field in question is a Long Text Field.
Create a query with the desired fields including the field to be searched.
In the "Criteria" row of the column/field to be searched put:
Like "*" & "The text to be found" & "*"
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
many thanks.
Your Welcome. Glad we could help.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick