access, query, sum

SELECT [IMTAnsatte].[Ansatt type], Count([IMTAnsatte].[Ansatt type]) AS [CountOfAnsatt type]
FROM IMTAnsatte
GROUP BY [IMTAnsatte].[Ansatt type];

Above is from a query made in access. In addition I'd like Access to make a summary of all the counts at the bottom.

Anybody know what I'm talking about?

thank you in advance

mr_friend

SELECT [IMTAnsatte].[Ansatt type], Count([IMTAnsatte].[Ansatt type]) AS [CountOfAnsatt type]
FROM IMTAnsatte
GROUP BY [IMTAnsatte].[Ansatt type]
UNION
SELECT "SUM" AS [Ansatt type], Count([IMTAnsatte].[Ansatt type]) AS [CountOfAnsatt type]
FROM IMTAnsatte;

Try this, You may have to play with teh syntax a little or the order

S-

sbaxter,

Thank you

It worked very well.

Sincerely
mr_friend