Setting Criteria Question 1

[khurley]

Hi !

I have field that I want to add to a query that calculates the number of days from todays date to Expiration date of policy. Easy enough to use DateDiff. This calc works for criteria of all policy types equal to A, S or R

BUT

If i have a Policy type of C then i want to substitute Cancel date for Expiration date in the calculation in my query.

I tried creating two different expr fields. EXPR 1 for DAtediff with expiration and another (EXPR 2) for Canceled.

Can i use these in another expr 3 field to compare somehow using if then else logic?

I basically want a field called #of days that will show the correct results based on policy type. If type of policy = A,S or R use EXPR 1 else use Expr 2.

HELP! This will feed a report!

 

[GingerR]

Please post your queries' codes. Have you tried something like:

FinalResult: iif(PolicyType = "A" or PolicyType = "S" or PolicyType = "R",Expr1,Expr2)

?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[khurley]

PERFECT Thanks so Much!!!