Question

Locked

Aggregat functions in Access

By usman_472 ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums