>Thank you-- I will try the shorter version. I was running out of room in the expression box, so this will help tremendously. I don't have enough experience with FP to be able to grasp alot of the short cuts yet, but I will get there I hope! I will study this one and log it for later use when I come across this again.
>:)
>
>CIT
In the situations like this I prefer to create a small UDF, which I place in the same directory, as a report. In this UDF you can use CASE statement, so the logic would be clear...
If it's not broken, fix it until it is.
My Blog