Getting a Percent from a returned row of data

I need to get a percentage of a number I am returning from a query, such as
My current returned columns are:

Year     count(acct type > 1)       % of acct type count with something > 1000
2000         122                                        10%
2001            85                                        32%


I can get the year and count of acct type, but I'm not sure how to get the % of that for the next column.
I'm guessing I need a variable for the count(acct Type > 1).

Any help is appreciated.

Thanks
David2112Asked:
Who is Participating?
 
David2112Connect With a Mentor Author Commented:
Ok,

Here's what I did.
Thankfully, I had to put this into an Excel spreadsheet, so
I just got the percentages from an additional query and did a COUNTIF to get the percentage based on the month.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.