How to find specific words in a field query [closed]
Hello,
I have a table named John for my Bible Study Class. 6 Fields; Id, Testament, Book, Chapter, Verse, Passage.
I would like to be able to query the passage field so If I type in text like ’truth’ it will return the chapter, verse and passages that contain that word. My problem is that no matter what word I try under criterion for passages field, There are no records. Am I doing something wrong? I did query in design view and had the words I was looking for like 'truth' in single quotes next to criterion. No results. Everything else works for example if I put '28' under criterion for the verse field, It returns all verse 28 chapters and passages. Thanks for help if possible.
In the future, please do not check the Community Wiki box when asking questions. For more suggested guidelines, see https://ask.libreoffice.org/en/questi....