Conditional formatting equal numbers - (as in tied scores in a report)

S

seekrane

I'm looking for a soloution for this problem. Is there a way to
highlight equal numbers in a report that shows point standings. I need
to be able to show tied scores, or make them stick out so that they do
not get overlooked.
 
K

KARL DEWEY

Try adding another query that finds the value of the ties - totals query
count >1 would do it. Then displayTIE in an adjacent textbox when the score
matches.
 
F

fredg

I'm looking for a soloution for this problem. Is there a way to
highlight equal numbers in a report that shows point standings. I need
to be able to show tied scores, or make them stick out so that they do
not get overlooked.
Click to expand...

If you have Access 2000 or newer you can use conditional formatting.
Select both controls. Click on Format + Conditional Formatting.
Set the Condition1 drop-down to Expression Is.
Write:
[Field1] = [Field2]
Select whatever colors you want.
Save the change.
 
S

seekrane

This way would not work for me. The report is made from a query that
totals an individuals points, so the [TotalScore] column is the only
place that the condition has to work from. Still stumped
 
Top