KennethMelvin
8 years agoQrew Trainee
Trying to produce a Summary Report of Multiple Multiple Choice fields.
I have a database with quite a few records that I've created to track a process end to end, but they different types of record use different parts of the whole process. The database stores the dates of different parts of the process being started and completed (it's in Working days currently).
I've set up a field to compare the duration of each process section vs the targets for the duration of that part of the process. However, that means that all of the 11 comparison fields are Multiple Choice fields that indicate when the Duration is on or below the target with a " Yes", over with a "No", or does not have either a start and/or end date (ie Null value) which produces a 'No Value" entry.
It is quite possible for similar records to omit different parts of the process, thus there will be Null values in the durations as well as 'Yes' and 'No'.
What I would like to do is produce a Summary report with 2 rows (first a count of the 'Yes' and the second a Count of the 'No') for each year.
It would be grouped by Year, Record Type and Module.
My problem seems to be understanding how to build this (and/or whether you need to set up another table to lookup those figures to get that detail) or whether a Summary report might be able to do this (currently I don't see that utility).
Any help would be appreciated.
I've set up a field to compare the duration of each process section vs the targets for the duration of that part of the process. However, that means that all of the 11 comparison fields are Multiple Choice fields that indicate when the Duration is on or below the target with a " Yes", over with a "No", or does not have either a start and/or end date (ie Null value) which produces a 'No Value" entry.
It is quite possible for similar records to omit different parts of the process, thus there will be Null values in the durations as well as 'Yes' and 'No'.
What I would like to do is produce a Summary report with 2 rows (first a count of the 'Yes' and the second a Count of the 'No') for each year.
It would be grouped by Year, Record Type and Module.
My problem seems to be understanding how to build this (and/or whether you need to set up another table to lookup those figures to get that detail) or whether a Summary report might be able to do this (currently I don't see that utility).
Any help would be appreciated.