I have a report that lists 10 Clubs with Win/Loss details next to each one.
I want to shade only the top four Clubs and their details. Is this at all possible? Thank you for any assistance you can offer.
I have a report that lists 10 Clubs with Win/Loss details next to each one.
I want to shade only the top four Clubs and their details. Is this at all possible? Thank you for any assistance you can offer.
You have to assign a ranking value to the records and use that rank value as criteria for conditional formatting.
For ranking technique, review the links in this thread https://www.accessforums.net/queries...-id-18836.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.