Re: BETWEEN . . . AND Operator
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 8 Jul 2008 22:16:18 +0800
John, create a table where you can enter the value and matching text.
This is much easier to maintain. You can tweak the values or add ranges just by updating the table, and everywhere in the software behaves consistently.
Tom Ellision explains how to set up such a table here:
http://allenbrowne.com/ser-58.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John Drake" <JohnDrake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4CEC0B00-326B-44E1-97C9-3CDD392148CF@xxxxxxxxxxxxxxxx
I have a text box in a form and in the CONTROL SOURCE of this text box I
want to use and IFF fuction that evaluates a number.
If the number is between 200 and 250, then it must print "FINE", if not it
should print "CRITICAL".
How will it work if I have more than 5 such BETWEEN ... AND statements for
the same field.
The field name in which this number is located is called Results.
.
- References:
- BETWEEN . . . AND Operator
- From: John Drake
- BETWEEN . . . AND Operator
- Prev by Date: Re: How do I set focus to an item in a list identified from another form?
- Next by Date: Re: BETWEEN . . . AND Operator
- Previous by thread: BETWEEN . . . AND Operator
- Next by thread: Re: BETWEEN . . . AND Operator
- Index(es):
Relevant Pages
|
