Only pull records last two digits are 50 - 99 of a 7 digit number

[lindagoodwin]

I am using Crystal 10.0.
I am working with a number field (Patient MRUN). I only need records for patients that the last two digits of the Patient's MRUN is from 50 - 99.

Example:

Field is formatted like this

67,610.00

I use the following formula to have it format correctly.
picture(totext({V_ABSTRACT_CONCISE.PATIENT_MRUN},"0000000"),"xxx-xx-xx")

It now reads 006-76-10. I only need to pull records for patients with the last two digits of 50 - 99.

Any help would be greatly appreciated. Thank you

 

[lbass]

right({@yourformula},2) in 50 to 99

-LB

 

[fisheromacse]

maybe this will help:

right((totext({V_ABSTRACT_CONCISE.PATIENT_MRUN},"0000000"),"xxx-xx-xx"),2)

 

[lindagoodwin]

I used this and it worked.

right(picture(totext({V_ABSTRACT_CONCISE.PATIENT_MRUN},"0000000"),"xxx-xx-xx"),2) in "50" to "99"


Thank you so much. You make my job a less stressful!

 

[lbass]

Oops, I forgot to make the values strings.

-LB