Comparing Data In The Same Field In Two Records of Same Table
Is there a method to compare the same field in two different records in a table to end up with a calculated result in both records.
Forum Discussion
Hey Mark, how are you? No, separate player each playing 18 Holes.
The competition is what we refer to as a Skins Competition. Regardless of how many players in the field, I want to be able to identify the player with the lowest score on each hole.
Right now we do it by generating 18 reports (one for each hole) sorting the scores for that hole from lowest to highest. (so it is tedious and takes time to collect or open each report).