Relating to a number range

[mattc]

Is it possible to have a related file that contains a defined number range which could provide a text result.

i.e. >100 and <200 = "Print this text"

So if 150 is entered in another related file, the above TEXT result is given.

To my knowledge, the AND,OR,XOR only return a logical 1/0 result.

Is there another way around - I'm probably overlooking an obvious answer!

[Chuck]

quote:

---

Originally posted by mattc:

Is it possible to have a related file that contains a defined number range which could provide a text result.

i.e. >100 and <200 = "Print this text"

So if 150 is entered in another related file, the above TEXT result is given.

To my knowledge, the AND,OR,XOR only return a logical 1/0 result.

Is there another way around - I'm probably overlooking an obvious answer!

---

The easiest way I can think of to do this would be to have a calculation for each range, and use that for the relationship.

So, you might have an equation like the following:

Range = Case(

Number_Field < 100, 1,

Number_Field >= 100 and Number_Field < 200, 2,

0)

Then have each instance of your related record use the Range number as the related field.

Range Text

===== ====

1 "Text for first range."

2 "Text for second range."

Chuck