Test in Corss tab Query value field

[yarub]

Hi,
I have set up a cross tab query as follows, I want to enter a text like “Yes” and “No”, if there is a value or if its blank.
I tried iif( x= “ “, “No”, “Yes”) , BUT this doesn’t work..

Any suggestion. Thanks for your help.

Tanvir


Design:

Short Name ProcessDate Allocation

Group By Group BY

Row Heading Column Heading Value

----------------------------------------------------------Preview:

Short Name July,2002 Aug,2002

ABA equity Equity
DEF equity
GHQ Equity
LMN Equity Equity