If I change the 'sort' to be by the surname then all 4 show up. Its only
when the summary sort is confronted with two of the same numerical value.
Lee wrote:
Hi,
I have a summary problem . My aim is to display a list of people with
their test scores in order of the highest score at the top of the page.
Within the file there may be up to four separate listings for each
person as 4 assessors have been entering assessments.
I have used a self relationship to total the scores for each person.
It all works fine, unless there are two people with the same test
score. When this happens only one person is listed and the other is
not displayed.
In my test sample there are 4 people but when two people have the same
score only 3 are displayed in the summary when it is sorted (descending)
I'm sure there must be a way to display all four.
Any ideas out there please.
Lee
--
