422,727 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,727 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, 5 views)
3 Days Ago #1
Share this Question
Share on Google+
3 Replies

Expert Mod 100+
P: 2,297

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 Days Ago #2

P: 2
YES! Thank you!
Sometimes the easiest things are the things I struggle with :)
3 Days Ago #3

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

Happy coding!
3 Days Ago #4

Post your reply

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