Getting Percent of Total

  • Thread starter Thread starter Robert N.
  • Start date Start date
R

Robert N.

In our business (temp staffing) we use Access to track
the shifts our temps work. I've developed a query that
counts the number of rows each "scheduler" has entered
for a given date range. If I want to see what percent
was done by any given scheduler I have to copy the
results to excel, sum the "counted rows" column, then
divide each schedulers count into the sum. Is there any
way to do this in a query? Thanks, Rob.
 
You can do it with two queries, or on one report.

Two query method - Query 1: Total Values Query 2: Sum of part Link together
to get the %
Report method - Add a field in the report to calc the Part / Total.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top