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.