Getting percentages of counts

[Guest]

Hi,
For me I like using the following....
=Sum(Abs([d3]="Monday"))
D3 is a field that has 7 possible responses....the days of the week.

BUT when all is said and done.....I get my say....23 people saying Sunday.
However...other days are chosen and there were 60 responses.
So my question is...
How do I get the percentage?
Originally I tried the following but it does not work.
=Sum(Abs([d3]="Monday"))/(=count([d3])
Thanks in advance for any help or guidance.
Sincerely,
Ken

 

[Duane Hookom]

Try:
=Sum(Abs([d3]="Monday"))/Count([d3])

 

[Guest]

Awesome! Thanks so much!

Try:
=Sum(Abs([d3]="Monday"))/Count([d3])


--
Duane Hookom
MS Access MVP
--

Hi,
For me I like using the following....
=Sum(Abs([d3]="Monday"))
D3 is a field that has 7 possible responses....the days of the week.

BUT when all is said and done.....I get my say....23 people saying Sunday.
However...other days are chosen and there were 60 responses.
So my question is...
How do I get the percentage?
Originally I tried the following but it does not work.
=Sum(Abs([d3]="Monday"))/(=count([d3])
Thanks in advance for any help or guidance.
Sincerely,
Ken