Report conditional format not working as expected

[Geoff Codd]

Hi there,

I have a report included in the attached db which has a field TotalUnits, and a calculation average of total units. I have set conditional formating to red and bold total units where it is more than 10% higher than average total units.

But this doesn't seem to work as expected any ideas appreciated

Thanks
Geoff

 

[suepowell]

Hi Geoff

I tried to look at your report, buth because the tables are linked, and therefore not on my PC, I can't open the report to see what the problem is, If you can post some sample data in the tables I will have anothe rtry

Sue.

 

[Geoff Codd]

Thanks sue, silly old me

thanks
geoff

 

[suepowell]

Hi

I have had another look and have an answer for you.

You were very nearly right, but just needed to put the name of the control who's value you wanted to compare the total to, instead of the calculated value.

ie [Avg Of SumOfUnits] ( the name of the control for the daily average) instead of (Avg([TotalUnits])*1.1) (the value of that control).

This works fine on my access 2002.


Sue

 

[Geoff Codd]

Thanks Sue,

That works a charm, I knew it had to be something simple

Thanks
Geoff