Web Development

Ask something
Question Locked

Aggregat functions in Access

0 helpful
1 reply

by usman_472

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.