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

Kevinski · Jul 17, 2003

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 · Jul 17, 2003

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Kevinski

Technical User

lbass

Technical User

Similar threads

Part and Inventory Search

Sponsor