Hi,

I have created a report in Access 2000. While using following condition in the value of the field, I am getting error...

iif ([APPRVALUE]=0,[SALESPRICE],[APPRVALUE])

It gives error for all records that has APPRVALUE(>0). Now if I change as...

iif ([APPRVALUE]=0,[APPRVALUE],[SALESPRICE])

it gives error for all records that has SALESPRICE(>0).

If I enter as...

iif ([SALESPRICE]=0,[APPRVALUE],[SALESPRICE])

it gives error for all records that has SALESPRICE(>0). !!!!!!!!!!!

In other words, what ever I have as FALSE partas non-zero, it would give me an error!!

Any idea please???