TRANSFORM IIf([employ]+[unemploy]=0,0,First([employ]/([employ]+[unemploy]))) AS Unemp
SELECT Index.Parish
FROM [Index] INNER JOIN [Employment – Monthly] ON Index.Par_FIPS = [Employment – Monthly].PAR_FIPS
WHERE (((Index.Parish) Like “A*”))
GROUP BY Index.Parish
ORDER BY Index.Parish, [Employment – Monthly].YEAR_MONTH DESC , [Employment – Monthly].YEAR_MONTH
PIVOT [Employment – Monthly].YEAR_MONTH;
Above is my Access Query and i m getting the error that the query cannot be used as an aggregate function
Please reply
asap
thnx
Mani
