Conditional formatting

[dave6298]

I recently had an issue with a conditional format on a control in a report, and what it appears to have done to some of my data. The control was calculating and displaying a percentage of worker efficiency on various jobs. The efficiency is the amount of time taken to complete a job versus the 'standard time' allowed to complete the job. I wanted to highlight anything less than 100% efficient, so I applied conditional formatting to change the background and font color if the calculated value was less than 1 (displayed as 100% in percent format).

In the same report I also keep a running sum of all of the individual jobs so that I can show an overall efficiency in the report footer. This running sum value summed up just fine in the detail section of the report. However, when I went to calculate the overall efficiency in the footer section the value had ONLY the value from the calculation of the first record, no other records were summed up.

As I was troubleshooting I discovered (after lots and lots of trial and error) that all I had to do was remove the conditional formatting from the detail section control to make the report footer sum and calculate properly.

Am I doing something wrong here or did I just discover some type of Access bug?? Any help or suggestions would be greatly appreciated. Thanks.

 

[Brianwarnock]

It workd ok for me, there must be more to it.

Brian

 

[greyhound48]

Same Problem

I noticed the same problem. I attached a sample. What I was attempting to do was highlight on field on my report if a condition was met. I didnt want to highlight the whole line by using vb code. So I just right clicked on the field in the detail sectional and selected [conditional format]. I entered my conditional and background color. But when I run the report it messes up the group totals. I included 2 examples. One working and one broken.

Please Help if you have an answer to fix this.

 

[Brianwarnock]

Hello Greyhound,
I've looked at your 2 reports and I cannot see any difference except for the conditional red background, both Jan totals are 2516 and Feb2.

I'm using Access 2002 SP3.

Brian

Have attached a screen shot.

 

[greyhound48]

Broken Report Screen print

Thats pretty weird. I am using Access 2003 and I have attached a screen print of what I am seeing.

Thanks to anyone who put in time to look into this.

 

[Brianwarnock]

Its really wierd, your running sum is correct, why not the Total in the Group Footer? Have you tried just doing the total not as the running sum?

Brian