Record Selection formula

[trikky]

Hi

I'm trying to pass a Recordselection formula from VB to CR. The formula I
wish to pass is a range, which is very straight formward I hear you say,
however I 'm finding problems becuase I wish to use LIKE aswell.

Below is the following point that I've got to:

Original ' IN BETWEEN ' formula


{Area.Name} in "AREA 1" to "EAREA1"

Modified ' IN BETWEEN ' formula with 'LIKE' operater

{Area.Name} in (({Area.Name} like "A*&quot) to (({Area.Name} like
"E*&quot)

However this does not seem to work.

Any ideas how I can achieve this.

Kind Regards

Rikesh

 

[Naith]

Rikesh,

What is the point of this?

If you are stipulating a range, of say A* to Brighton - then this already includes all the A* wildcard values. You don't need a wildcard and a range.

Similarly, if you only want to include half of the A* values, then surely a range or Aberdeen to Ashton will already ignore all the areas alphabetically after Ashton.

If you want to use wildcards, then you abandon the range approach:

{Area.Name} >= 'A*'
and
{Area.Name} <= 'E*'

Naith