423,491 Members | 2,205 Online
Need help? Post your question and get tips & solutions from a community of 423,491 IT Pros & Developers. It's quick & easy.

# Creating a Percentage Box from two different =Count text boxes

P: 2
I have a very simple table that has only four columns.
1) College
2) Department
3) Employee
4) Completed Date

I have created a report using groups and totals.

the College is the first level, the department is the next. I then ONLY want to know how many people are in each department, how many completed the training (I have succeeded this far) but I need to create a new field that divides the total number of completions by the total number in the department to return a percentage.

The EMPLOYEE filed has a text box with this: =Count(*)
THE COMPLETED DT has a text box with this: =Count([COMPLETED DT]

How do I write it so that I can come up with a percentage returned for the =Count([COMPLETED DT] divided by the =Count(*) ?

The texbox names are AccesTotalsEMPLOYEE and AccessTOTALSCOMPLETED DT

Thank you!
Attached Files
 Training Pic.docx (1.51 MB, 33 views)
Jun 14 '18 #1

tejajean,

Welcome to Bytes!

Simply create a new text box named AccessCompletePercent. Its record source will be `= [AccesTotalsEMPLOYEE]/[AccessTOTALSCOMPLETED]`

All should be fine after that.

Hope this hepps!

3 Replies

 Expert Mod 2.5K+ P: 2,608 tejajean, Welcome to Bytes! Simply create a new text box named AccessCompletePercent. Its record source will be `= [AccesTotalsEMPLOYEE]/[AccessTOTALSCOMPLETED]` All should be fine after that. Hope this hepps! Jun 14 '18 #2

 P: 2 YES! Thank you! Sometimes the easiest things are the things I struggle with :) Jun 14 '18 #3

 Expert Mod 2.5K+ P: 2,608 Glad I could be of service. I've made plenty of head-scratching mistakes in my time. Happy coding! Jun 14 '18 #4