423,113 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,113 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
File Type: docx Training Pic.docx (1.51 MB, 23 views)
Jun 14 '18 #1

✓ answered by twinnyfo

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!

Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 100+
P: 2,499
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

twinnyfo
Expert Mod 100+
P: 2,499
Glad I could be of service. I've made plenty of head-scratching mistakes in my time.

Happy coding!
Jun 14 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.