How do I Format Max(Value) in a Report to be Bold

[Crownknox]

I am working an a stats report that gives detailed info for individuals.

(For Example: If an individuals [Daysworked] is more than anyone else, I would like it to be bold or another color.)

I've tried using an if...Then statement in the OnFormat section but I get errors about using Max([Daysworked])

Should I be using Max??

Any help would be appreciated.

 

[HowieG]

Try using:

DMax("[Daysworked]","[YourTable]","[IndividualID] = " & IDNum)

Or some variant of that.