Conditional formating / Addition question

J

Jade Paterson

Hi,

I have a report that I'm having problems with I need to color the two top
figures of a calculation I have in my query
CYCalc: IIf([CYEarnings]>0,[CYEarnings]/[CYStarts]*1000,0)
I need the top value to print in "red" and the second top value to print in
"green" in each group sorted by race/by contestant.

I also need to add the latest two values sorted by date in a group on my
report
6/29/05 - blah - blah - blah (this value) 45 - Blah - Blah
6/10/05 - blah - blah - blah (this value) 52 - Blah - Blah
5/20/05- blah - blah - blah (not this value) 44 - Blah - Blah
5/10/05- blah - blah - blah (not this value) 42 - Blah - Blah

Thanks for your help

Jade
 
Top