I created a report for a fitness competition DB with fields from a query eg "AgeGroup" (A,B,C,D)ect, with the protocols "2,4Km" points Field , "4Km" points Field and a "Total Score" field that is the sum of all the protocol points, the report is grouped by "AgeGroup" field and ascending on the "Total Score" field, I need to highlight the top 3 scores of each age group is that possible.
Kevin Yip
@Reply 3 years ago
If it's ascending, the top scores will be at the bottom of the list. Do you mean descending? If so, the top scores will be the first 3 rows. You can set up a counter variable in VBA to count the rows being printed, and set the background color accordingly. Below picture is an example. The counter needs to be set to zero initially (in the report's Open event in my example). One is added to it every time a row is printed (in the report detail's Format event). If the counter is <= 3, you set the proper background color.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
