V
vikram_singh
Hi,
M getting error (Invalid use of Null) with crosstab where i have used
left outer join. I tried different ways to get rid of error message
but it follows all the time. I tried using "Nz" "IIF" but didnt
work. Please help if someone can help me on my below query.
TRANSFORM Sum(IIf([ANR]>0,[ANR],0)) AS Expr1
SELECT report4.country
FROM report4 LEFT JOIN REPORT4_ACTUALS ON (report4.PL =
REPORT4_ACTUALS.PL)
GROUP BY report4.country
PIVOT REPORT4_ACTUALS.Expr2
Thanks in advance,
Vikram
M getting error (Invalid use of Null) with crosstab where i have used
left outer join. I tried different ways to get rid of error message
but it follows all the time. I tried using "Nz" "IIF" but didnt
work. Please help if someone can help me on my below query.
TRANSFORM Sum(IIf([ANR]>0,[ANR],0)) AS Expr1
SELECT report4.country
FROM report4 LEFT JOIN REPORT4_ACTUALS ON (report4.PL =
REPORT4_ACTUALS.PL)
GROUP BY report4.country
PIVOT REPORT4_ACTUALS.Expr2
Thanks in advance,
Vikram