I have just upgraded to Access 2000 and have been playing with the conditional formating function. I like it a lot.
I can use this function correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer is basically summing my detail and also taking the percent change from one month to the prior month. I am highlighting those percent changes that are above 5% or below -5 percent with a different font and color.
Am I doing something wrong or is this a common problem?
I can use this function correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer is basically summing my detail and also taking the percent change from one month to the prior month. I am highlighting those percent changes that are above 5% or below -5 percent with a different font and color.
Am I doing something wrong or is this a common problem?
