Dear Experts,
I'm working on a report that has a formula to figure out the median value for a group of records. It looks like this:
Facility Name Group Header
Facility Name field value
Facility 1 Value 1
Facility 2 Value 2
Facility 3 Value 3
Facility Name Group Footer
Median value for field: Value 2
The people who have been doing this have all the records on a spreadsheet, and they go through it and manually figure out which record has the median value and they've been highlighting that record in yellow. Is there any way I can have Access go back and highlight record 2 after it figures out that Record 2 has the median value?
Thank you for all your help.