IsError not working

[vikram_singh]

Hi,

I have a query and i am writing

SELECT report4.country, REPORT4_ACTUALS.ANR, REPORT4_ACTUALS.EXPR2
FROM report4 LEFT JOIN REPORT4_ACTUALS ON (report4.PL =
REPORT4_ACTUALS.PL)

if i execute the above it works fine except showing one error
message #Error in REPORT4_ACTUALS.EXPR2 Column. To handle the #Error
if I also modified the query saying
IIF(ISERROR(REPORT4_ACTUALS.EXPR2)=TRUE,"",
REPORT4_ACTUALS.EXPRT2) ...BUT SOCKINGLY IS NOT WORKING. it still
shows #Error.... And when i add one more line say "Group By " then i
get error Invalid use of Null". REPORT4_ACTUALS.EXPR2 is coming from
another query which is a comibination of 2 Numeric fields which are
year and quarter so finally I get value like "2007 - Q1" after
concatenating.

Please give ur kind advice.

Regards,
Vikram

 

[david]

Unfortunately, that is a completely different kind of error.
There is no way you can use "IsError" here, and there is no equivilant you
can use here.

You will have to fix the REPORT4_ACTUALS.EXPR2 value. It is probably finding
a null, so you will probably have to fix that.

(david)