Ask Your Question

leoirias@hotmail.com's profile - activity

2018-03-09 03:44:06 +0100 received badge  Famous Question (source)
2017-11-25 16:46:51 +0100 received badge  Notable Question (source)
2017-11-25 02:46:54 +0100 commented answer How to find specific words in a field query

Thank you for the advice. I did everything exactly like the screenshot. It worked. I did not try the parameter input box

2017-11-25 02:44:02 +0100 marked best answer How to find specific words in a field query

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.

2017-11-25 02:44:02 +0100 received badge  Scholar (source)
2017-11-25 02:35:07 +0100 commented answer Guidelines for asking

Thanks, for the tips.

2017-11-24 21:56:29 +0100 received badge  Popular Question (source)
2017-11-24 02:19:33 +0100 edited question How to find specific words in a field query

How to find specific words in a field query Hello, I have a table named John for my Bible Study Class. 6 Fields; Id, Te

2017-11-24 02:17:46 +0100 asked a question How to find specific words in a field query

How to find specific words in a field query Hello, I have a table named John for my Bible Study Class. 6 Fields; Id, Te