Read only part of a field 1

[scottaherbst]

Sorry, I'm sure this is a total newbie question as I am pretty much a newbie to this program.

When making my report, I want to exclude records that contain the characters "rx" (e.g., 103rx2) and that end in a 3. How do I do this.

Thanks

 

[Turkbear]

Hi,
Use the Crystal string functions in your selection criteria formula to exclude those...The help files should have examples..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Try Report->Selection formula->Record and use something like:

(
not({table.field} like "*rx*"
)
and
(
not(right(MyField,1) = 3
)

Please at least post your software version in the future, you should also include the database used.

-k