Jump to content

Relating to a number range


mattc
 Share

This topic is 7609 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7609 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.