V
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
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