Conditional Formatting on a Report

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have a report listing scores of tests taken, so an employee can have many
test scores. I have already created a text box called txtCount so that only
the two recent scores are displayed. What I want to see, if the most recent
score is less than their previous score, to colour it red. Can I achieve
this? I'm using 2003

Thanks

Nigel
 
I expect you need to get the two scores returned in the same record/row of
the report's record source. This is typically accomplished with a subquery or
similar.
 
You could search the web on "Ranking subQuery query" or reply back with your
table structure, the data types, some sample records, and desired output.

Duane Hookom
MS Access MVP
 
Hi Duane

I'll try searching first, I'll enjoy the challenge of finding out!

Many thanks.

Nigel
 
Back
Top