I currently have a query that counts up all the different types of "Return Methods" from customers. Here is an example of what I currently have:
What I want to do is add a thrid column that converts the count, to a percentage, of the total. Here is an example (in YELLOW) of what i'd like to add to this qry:
The new "%" column would take the count of 1 field and divide that by the sum of the entire column.
I have searched all over, but I cannot find out how to do this. Also as an FYI, I am not familiar with SQL if its possible id like to be able to add this using 'Design View". But I am open to the easiest solution. Thanks!