Case Function Eval to Blank

  • Follow


Win XP, FMP 9

Have a simple Case function that evaluates as expected  if test has  result 
but if tested field is blank or there is no correct result then default 
would be expected but result field is blank and not value in "Default" 
answer.

Case (Code 1="F 1" ; "Family" ; Code 1 = "TAD";"TAD";Tradesman = "T" ; 
"Trade" ; Code 1 = "";"Others";"Others" )

If code 1 is Blank then neither the last test or the default set the output 
to "Others" as desired.

Any Ideas please.

John G. 


0
Reply green1979 (15) 9/8/2008 4:05:26 AM

"John G" <green@ozemail.com.au> wrote in message 
news:48c4a47e$0$32012$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> Win XP, FMP 9
>
> Have a simple Case function that evaluates as expected  if test has 
> result but if tested field is blank or there is no correct result then 
> default would be expected but result field is blank and not value in 
> "Default" answer.
>
> Case (Code 1="F 1" ; "Family" ; Code 1 = "TAD";"TAD";Tradesman = "T" ; 
> "Trade" ; Code 1 = "";"Others";"Others" )
>
> If code 1 is Blank then neither the last test or the default set the 
> output to "Others" as desired.
>
> Any Ideas please.
>
> John G.
Forget It.

I even looked for "Do not evaluate if blank"
Now I have found it ... Problem solved.

John G. 


0
Reply green1979 (15) 9/8/2008 4:42:00 AM


1 Replies
44 Views

(page loaded in 0.103 seconds)

Similiar Articles:













7/14/2012 10:57:02 AM


Reply: