Access Query/Report Calculations

[chrisescarcega]




This is how my query is currently set up. I want to add another column next the "Results" field that will take the counts in the "Results" column and divide it by the total count of results.
My report is currently set up as follows:
I've created a group by merchant. The third column shows the number the count of each results with total number of results for that specific merchant. All I want to do is create an expression/calculation where I can take the count of each result and divide it by the total results of for that merchant. How can i do this through the report or query. Thank you in advance.

[isladogs]

If I'm understanding you correctly, one common way to do this requires 3 queries.
1. Your query shown above
2. Do another aggregate query to get the overall totals by merchant.
It needs two fields - the 'merchant' field twice - group by & count

3. Then join queries 1 & 2 by the 'merchant' field (is that Source?) & add your calculated expression field

[chrisescarcega]

If I'm understanding you correctly, one common way to do this requires 3 queries.
1. Your query shown above
2. Do another aggregate query to get the overall totals by merchant.
It needs two fields - the 'merchant' field twice - group by & count

3. Then join queries 1 & 2 by the 'merchant' field (is that Source?) & add your calculated expression field

Hi,

Yes the source is the Merchant. What calculated expression can I use?
Thank you!

[chrisescarcega]

Nevermind I was able to figure it out. Thank you!