Access Report, Conditional Text

[David]

I currently have a report that lists employees and the points they
have. This information is edited through a form.

Currently on the report I have...

EMPLOYEEID NAME POINTS
CZ323 John Smith 2

What I'd like for it to do is show the number of points but beside it
give their status depending on the points they have. For example...

If points < 5 = no status text
If points >4 AND <7 = Verbal Warning
If points >6 AND <9 = 1st Written Warning
If points EQUAL 9 = 2nd Written Warning
If points >= (GREATER OR EQUAL) 10 = Review Board

Plain text of the above:
(0-4) NONE
(5-6) Verbal Warning
(7-8) 1st Written Warning
(9) 2nd Written Warning
(10) Review Board

I don't know how to make this work. This can be a text field beside the
points I just don't know how to make certain text display on a
condition. Thanks for your help in advance!!!

[jimfortune]

David wrote:

I currently have a report that lists employees and the points they
have. This information is edited through a form.

Currently on the report I have...

EMPLOYEEID NAME POINTS
CZ323 John Smith 2

What I'd like for it to do is show the number of points but beside it
give their status depending on the points they have. For example...
...

This problem seems similar to:

http://groups-beta.google.com/group/...c59165e0c16021

which involved different messages to students based on numerical
grades. Post back if Richard's technique won't work for you.
James A. Fortune

[Christina Grabe via AccessMonster.com]

Why not try a Select Case?
Select Case points
Case points < 5
result = " "
Case points >= 5 AND <= 7
result = "1st Warning"
etc...
Case Else
(Default result)
End Select

Maybe this'll work without all the frustrating and cluttered ElseIf's

--
Message posted via http://www.accessmonster.com

[jimfortune]

Christina Grabe via AccessMonster.com wrote:

Why not try a Select Case?
...
Maybe this'll work without all the frustrating and cluttered ElseIf's

--
Message posted via http://www.accessmonster.com

That's a good idea. You can tell from my response he quoted that I
envisioned using Select Case.

James A. Fortune

[jimfortune]

Chuck Grimsby wrote:

The Switch function can also be useful here....

On Wed, 29 Dec 2004 18:40:35 GMT, "Christina Grabe via
AccessMonster.com" <fo***@AccessMonster.com> wrote:

Why not try a Select Case?
Select Case points
Case points < 5
result = " "
Case points >= 5 AND <= 7
result = "1st Warning"
etc...
Case Else
(Default result)
End Select
Maybe this'll work without all the frustrating and cluttered

ElseIf's

--
Sects! Sects! Sects! Is That All Monks Think About?

Using the switch function can replace the user-defined function
entirely, especially since there are fewer cases to consider.

James A. Fortune

When you're in the zone you'll run five maybe 10 racks in a row. Then
someone, maybe me, will say, "Nice shooting, Jim." But you won't think
about it while shooting. There's no adrenaline. You just put your
conscious mind in the background and let the subconscious take over.
To your mind say, "Let the body play." --- Jeff Macauley

[Bob Quintal]

"Christina Grabe via AccessMonster.com"
<fo***@AccessMonster.com> wrote in
news:16******************************@AccessMonste r.com:

Why not try a Select Case?
Select Case points
Case points < 5
result = " "
Case points >= 5 AND <= 7
result = "1st Warning"
etc...
Case Else
(Default result)
End Select

Maybe this'll work without all the frustrating and cluttered
ElseIf's

I have a quibble with Case points >= 5 AND <= 7
In a case structure, as long as you process in numerical
sequence, you only need to test for the upper limit, since the
previous test will have handled the lower limit.

Therefore
Case <5
Case <7
Case <9
Case <10
Case >=10
Case Else ' Handles nulls and errors

--
Bob Quintal

PA is y I've altered my email address.

[jimfortune]

Bob Quintal wrote:

I have a quibble with Case points >= 5 AND <= 7
In a case structure, as long as you process in numerical
sequence, you only need to test for the upper limit, since the
previous test will have handled the lower limit.

Therefore
Case <5
Case <7
Case <9
Case <10
Case >=10
Case Else ' Handles nulls and errors

--
Bob Quintal

PA is y I've altered my email address.

Nice optimization Bob. Another thing to keep in mind about Richard's
problem was that he wanted to use values from table(s) to be able to
change the limits by changing values in the table(s). David's example
is not as likely to change limits as quickly so the switch concept
looks promising.

James A. Fortune