Hello,
I got stuck on something that seems quite simple but I cannot figure this out..
I scouted a lot for an example but my SQL/VBA skills are so basic that if I found it, I didn't recognise it.
In this situation I've got 2 tables.
- First table "TrainProc", contains training information of employees including "Category" of a procedure that they have been trained on.
- Second table "Procedures", is a list of all procedures with another "Category" column for reference.
My aim:
I need to calculate percentage value of completed training.
If for example, an employee has a count of 2 records in "TrainProc" table for a category that has count of 5 in "Procedures" table, then it should return 40%.
Any advice?
Thanks!!
I got stuck on something that seems quite simple but I cannot figure this out..
I scouted a lot for an example but my SQL/VBA skills are so basic that if I found it, I didn't recognise it.
In this situation I've got 2 tables.
- First table "TrainProc", contains training information of employees including "Category" of a procedure that they have been trained on.
- Second table "Procedures", is a list of all procedures with another "Category" column for reference.
My aim:
I need to calculate percentage value of completed training.
If for example, an employee has a count of 2 records in "TrainProc" table for a category that has count of 5 in "Procedures" table, then it should return 40%.
Any advice?
Thanks!!