My DocNum field contains numbers like: C123456, P987654L, P223344, C112233
I'm trying to create a view query statement that will omit entries where DocNum contains L. However, nothing I've tried is working.
This shouldn't be hard, but I've wasted a few hours already - what is the correct syntax???
Ihaven't looked it up but I think contains returns true or false so try this: (Field Docnum contains L) = False AND ...
Wow - how simple! Thank you, Bill!
Did it work?
Yes, perfectly.
Edit: - Actually, no, it does not work - I get a "query not understandable" error.
I didn't notice it in my local database because all my data had the letter L. So, once they all disappeared, I thought it was working, but didn't notice the error on the console.
So, I'm back to square one - having no idea how to make this work. This should not be this hard nor should it be that uncommon to where I can't find anyone that's done it before.
I'm stumped, but I need a solution - any other ideas?
NOT [Docnum] CONTAINS L is the right syntax.
You may test it by composing a query that searches for a larger word say "P987654L" rather than "L" . ensure "P987654L" is indeed contained in a few documents as a DocNum Field, in the view being tested. This would work implying the above syntax is correct.
If documents containing "L" can be searched via a simple full text search, then NOT [Docnum] CONTAINS L would have also worked. I dont think single letters are being indexed. Search would usually return results if a significant portion of the text being searched for is contained in the field / otherwise in the document.
Hope this helps
Thank you for your prompt reply. Unfortunately, I can't search by a specific DocNum, because there could be hundreds of them. Since I can't simply look for a single letter, I changed my logic to use another field.
So, I still don't have a solution for looking for a single letter, but at least for now, I have this problem resolved.
Thank you again.