How would I use the left + len + InStrRev functions to start at the end of the field and find "$bill" and then return that text pluss the remaining string? I know how to use the right function to bring back the last few characters, but the issue is that the string after "$bill" varies. so I want to pull "$bill" and everything after that.
It would also be nice to have it return something like "***" if the remaining string was longer than X characters (ie 10 characters), as a way to indicate that the "$bill" code was entered wrong....this would tell me that either the person entered too many characters after "$bill". Alternate suggestions/approaches are welcome.
i.e. - the memo field would contain a string similar to below:
90 day EWP
five year, to be billed biennial. maturity date 11/13/18
5th 11/13/17 $bill52.2.1
Crystal Reports: 5 Tests for Top Performance
It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…