Right Function

[jtr9999]

I have a database field that is a number. I am trying to only return something if that database field is an odd number. I tried using the right function to do it but that didn't seem to work for me. What I tried is below. It doesnt like that it is a number. I tried converting the field to text but that didn't work. Any Suggestions? Thanks Jonathan

if right({Planee.PlanID},1) = '1'
or right({Planee.PlanID},1) = '3'
or right({Planee.PlanID},1) = '5'
or right({Planee.PlanID},1) = '7'
or right({Planee.PlanID},1) = '9' then
some return

 

[dgillz]

if remainder({YourField},2)=1 then "Odd number" else "Even number"

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?