Simple Crystal Formula

[SLindsay]

Hello,

I have a form which contains a field called Sequence, tha value of which is always either 1, 2 or 3. Depending on this value, I want a text box field to read either 1st, 2nd or Final.

Is it possible to achieve this in Crystal Reports with a simple formula or is there a better way to do it? I'm hoping someone can help this CR rookie jump this hurdle.

With thanks in advance

Scott

[Ranthalion]

You can create a formula in Crystal Reports using select...

select {Sequence} case 1 : "1st" case 2 : "2nd" case 3 : "Final" default: "bad value"

-Ranthalion