Trying to produce a Summary Report of Multiple Multiple Choice fields.

I think I take your overall point regarding parts of the process (and that is probably fair), but I'm not entirely sure I understand what you mean regarding '1 field'.

All of the different Durations (and check fields) are in 1 field each.

If you put them in a child table, your common duration calculation will only need to be made once.

Say you have 5 parts to the process; Plan, check, build, inspect, finish.
And you have a start date & end date for each of those, and in turn a duration.

If you make a child table you would need 4 fields on the child table;
[Part Type], multiple choice field (Plan, check, build, inspect, finish.)
[Start Date]
[End Date]
[Part Duration] = [End Date]-[Start Date]

Now you would have 5 child records for each part of the project, but the great part here is all your "durations" are in one spot, to if you want to make reports, that compare durations from one part to another, you can.

Overall, your reporting capabilities grow greatly because you have all 'like' data in one field.

It's not comparing it vs each other, it's comparing the actual figures to the target figures that they should be under, and seeing how many manage to get below the target and how many don't and counting those numbers.

Your point may be valid, but it doesn't help me with the current problem and will be an extended project that simply isn't going to happen any time soon. I'll look into making those changes, but at best they will need a significant amount of time and effort.