Conditional Formatting on a Report

[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

 

[Duane Hookom]

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.

 

[Nigel]

Thanks for your reply. How would I do this, please.

Thanks

 

[Duane Hookom]

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

 

[Nigel]

Hi Duane

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

Many thanks.

Nigel