Adding to a query for % of count, $$ and % of $$

[Guest]

I am new to this and appreciate any help that you can give me. I have a
table that I need to get a total responsibility accounting for broken down by
Responsible party. The following SQL gives me the count of appeals by
responsibility:

SELECT [Responsibility], Count ([Responsibility]) AS Appeals
FROM [Resolved by Hospice Date Worked]
GROUP BY [Responsibility];

I need to get the percentage of the whole for each responsibility from the
above query. In addition, I need the break down of actual money [Sales
Amount] broken Down by [Responsibility] and a percentage of same broken down
by responsibility.

I am trying desperately to learn this system, so if you can point me in the
right direction, it would be greatly appreciated. I have not budget for
training, but must learn this system.

 

[Michel Walsh]

SELECT Responsibility,
COUNT(responsibility),
COUNT(responsibility) / (SELECT COUNT(responsibility)
FROM [Resolved by Hospice
Date Worked])
SUM(amount),
SUM(amount) /( SELECT SUM(amount)
FROM [Resolved by Hospice Date Worked])
FROM [Resolved by Hospice Date Worked]
GROUP BY Responsibility



since, as example, COUNT(responsibility) in

SELECT COUNT(responsibility) FROM [Resolved by Hospice Date Worked] GROUP BY
Responsibility

is applied for the group, but

(SELECT COUNT(responsibility) FROM [Resolved by Hospice Date Worked])


is applied for the whole table, the division supply the percentage (ok,
multiply by 100 to get a real percentage).


Hoping it may help,
Vanderghast, Access MVP