I have designed a report to assess the risk of a project based on defined project elements.
The project elements are set up as fields in a table and projects as records.
After each project element is assessed, a score (from 1 to 5) is awarded and at the end of the day all the project element scores are averaged to produce an overall score for the project.
My report, based on a single project (and on a query which is the exact replica of the above table) currently displays all the project element fields regardless of the score but I’d like to display only 4 and 5 scores as these are the areas of concern to management.
How can I build in this kind of exception in my report to display side-by-side the relevant project element and its associated score??
Any help would be much appreciated.
The project elements are set up as fields in a table and projects as records.
After each project element is assessed, a score (from 1 to 5) is awarded and at the end of the day all the project element scores are averaged to produce an overall score for the project.
My report, based on a single project (and on a query which is the exact replica of the above table) currently displays all the project element fields regardless of the score but I’d like to display only 4 and 5 scores as these are the areas of concern to management.
How can I build in this kind of exception in my report to display side-by-side the relevant project element and its associated score??
Any help would be much appreciated.
