Hi I am new to here and relatively novac in Access (2007).
I was tasked to create report that contains different Key Performance Indicators (KPI) and they are broken down by month. So I have a CrossTab Query that is feeding the report. We have Jan, Feb, Mar... across the top and Location along the side. In addition I have "Group & Sort" field active which groups all this information.
What I am trying to do is to apply different Conditional Formats to my Detail of the report based on the different KPI groupings. Each KPI has different thresholds for applying color to the background. So I would need to make the Conditional Formatting depending on the KPI as well as its appropriate threshold..
Thanks so much
I was tasked to create report that contains different Key Performance Indicators (KPI) and they are broken down by month. So I have a CrossTab Query that is feeding the report. We have Jan, Feb, Mar... across the top and Location along the side. In addition I have "Group & Sort" field active which groups all this information.
What I am trying to do is to apply different Conditional Formats to my Detail of the report based on the different KPI groupings. Each KPI has different thresholds for applying color to the background. So I would need to make the Conditional Formatting depending on the KPI as well as its appropriate threshold..
Thanks so much
