How does one calculate a total count and then a percentage by month using a query

[btech1]

I'm hoping one of your more experienced people can please help me. I think I am missing osmehting simple in getting this query issue worked out. If there is a way for me to post a copy of the db I will for feedback and suggestions.
I need to do a count of "yes" an then do a percentage compliance by month. So if I had a possible 25 records and 12 were marked "yes" and the rest were marked "no" then I would want it to produce a compliance rate of 48% for those records under the month of June per se. Any suggestions would be greatly appreciated.

 

[fvd_1]

Hi, i'm not sure that this is the kind of solution your looking for but i think this is the formula you'll have to use: (100/[allrecords])*[yesrecords]
So you'll have to make a query that counts all the possible records (this field will then be [allrecords]) and another query that counts all the records that are set to "yes" (this field will then be [yesrecords] in your formula.
So, with your example this is: (100/[25])*[12] (=48)

Hope this helps...
Greetz!

 

[addis123]

How does the query in access look like. Help , I have a similar problem. Thank You