formule question

In my reports I have a list of numbers - the reports calculaids the averge of these numbers - Now I need the numbers below averge to turn red.

In my atemps to do this I have the problem that de correct averge number is caculated at the end of the report witch result in the fact that all my numbers from the second row turn red? :mad:

:confused: This hase my in a corner and I cant get out :cry:

Yes , u have to handlle this trough query , how ??

First u calculate the average of the numbers in a variable for example

Declare @avgnum numeric
set @avgnum=(select avg(number) from table1)

select number,@avgnum from table1

now u got the average with every number u r displaying , now u can write ur desired formula.