My problem is trifold. Hopefully this will make sense. Thanks for your time in advance.
I want to search for a key word in my notes field using a parameter (my goal).
My notes field {inmain.notes}is a memo not a string. So, I used a formula {@NOTES} to convert the memo field into a string field. The new formula field works on my report.
So now (i think), I can use the select expert to filter my new notes section (string) using my parameter (?SEARCH). This should filter out and search for words in my notes section. - THIS DOES NOT WORK.
So I back up, I try fixing an INSTR formula to filter out as True or False:
IF INSTR({@NOTES},{?SEARCH})>0 THEN TRUE ELSE FALSE - THIS DOES NOT WORK
IF INSTR({inmain.notes},{?SEARCH})>0 THEN TRUE ELSE FALSE - THIS DOES NOT WORK
If my delima makes sense to you and you know how I can search-a-word in my notes field, can you please help?
Thank You.
I want to search for a key word in my notes field using a parameter (my goal).
My notes field {inmain.notes}is a memo not a string. So, I used a formula {@NOTES} to convert the memo field into a string field. The new formula field works on my report.
So now (i think), I can use the select expert to filter my new notes section (string) using my parameter (?SEARCH). This should filter out and search for words in my notes section. - THIS DOES NOT WORK.
So I back up, I try fixing an INSTR formula to filter out as True or False:
IF INSTR({@NOTES},{?SEARCH})>0 THEN TRUE ELSE FALSE - THIS DOES NOT WORK
IF INSTR({inmain.notes},{?SEARCH})>0 THEN TRUE ELSE FALSE - THIS DOES NOT WORK
If my delima makes sense to you and you know how I can search-a-word in my notes field, can you please help?
Thank You.