Return a string even if there are no 'false' es

[Kevinski]

Hi

I have a formula based on an MS Access table where clients are asked yes or no if they are happy with service.

The formula reads:

if {ServiceFollowUps.Qn1} = true
then 'Yes - call can be closed/ invoiced'
else 'No - call has not been completed to satisfaction'

And I'm counting the replies and cross-tabbing them

Trouble is if there are no 'No' 's (as in most cases) I don't get the 'else' string returned. For impact on the report I want to return zeroes against the false test.

 

[lbass]

So the absence of any answer is what constitutes a "no"? Then your formula could be written:

if isnull({ServiceFollowUps.Qn1}) or
{ServiceFollowUps.Qn1} = '' or
{ServiceFollowUps.Qn1} = ' ' then
'No - call has not been completed to satisfaction' else
'Yes - call can be closed/ invoiced'

-LB