[AccessD] Percentages of Sub Totals

[Brad Marks]

Never mind.

I finally found an example on the internet and I now have this working.

Brad



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, August 07, 2015 3:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Percentages of Sub Totals

All,

I have an Access 2007 Report that shows the number of orders that have "Drop Ships" and the number of orders that do not have Drop Ships.

This report has Report Groups on  Quarter, and "Drop Ship Indicator" which gives us counts of Drop Ships versus Non Drop Ships for each quarter.  This works nicely.

Now there is a need to show a percentage of Drop Ships versus Non Drop Ships for each quarter.

I understand how to get a percentage of a final total, but I am not sure if there is a way to obtain a percentage based on another sub-total.

_ _ _ _ _ _

Current report snippet ...

     Drop Shipped      100
     Non Drop Shipped   900
Quarter 3 of 2013    1000 

_ _ _ _ _ _

Desired result ...

     Drop Shipped      100       10%
     Non Drop Shipped   900       90%
Quarter 3 of 2013    1000 

_ _ _ _ _ _


Thanks,
Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com