calculating a percentage

B

Belinda7237

I have a field Question 1aa that has a result of Yes or No
I also have a record id count for a particular month 9user enters a start
and end date)

The query will return a count of yes and no but i want to also add a
calculation in the query that includes the percentage of "yes" of the overall
count.


Percent yes: ([CountOfRecord ID]/[Question 1aa])

I am a novice - can anyone help in what the builder should look like?
 
M

Marshall Barton

Belinda7237 said:
I have a field Question 1aa that has a result of Yes or No
I also have a record id count for a particular month 9user enters a start
and end date)

The query will return a count of yes and no but i want to also add a
calculation in the query that includes the percentage of "yes" of the overall
count.

Percent yes: ([CountOfRecord ID]/[Question 1aa])
Click to expand...


Try using the expressions instead of the name of the
calculated fields. E.g.

Percent yes: Sum(IIf([Question 1aa],1,0)) / Count(*)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postal Code 5
Calculating Percentages Using a Query 3
Getting Radio Buttons to work, that are inserted via AutoText 0
Section and Page numbering 0
Percentage of month passed formula 1
Calculating Percentage of Column Data 1
Finding the Percentage of 'Yes' 2
Crosstab query with custom grouping 1

Top