value?

[Anonymous]

Hi

i have table called

country:   fields like

country:

india -100(value)

america-200

westindies-300

pakisthan-400

zimbambe-null

austrila-null

newzeland-null

in this table i am malking a croostable like

crosstable(allcountry,amount,2)

india and americal will remain same .

rest of the countries names or going store in  'allcountry'   and 

all these country data is going to store in  amount.   ,,,    fine till now

here 

zimbambe

austrila

newzeland                   dont have value it is having null  .

when i go for table box with above fields

india

america

allcountry

amount

i can see data  in allcountry for only  westindies,pakisthan( where i have value)   ,(not only data even fields are not coming up in allcountry called  zimbambe, austrila ,newzeland)

my req is  i want see these fields also in all country(zimbambe, austrila ,newzeland)  even if value is null

and it should not display 0 instead of null

i have  to see  only null  ( i dont want see any thing instead of null)