I can get the result I require except that it will not sort by the final
total as its a summary field and the sort command will not sort by a
summary field
Lee wrote:
I should have also advised that a number of entries are made with
numerical performance levels for each client for each category by a
number of 'judges'. Therefore there could be 10 scoring 'cards' for
each client to be summarised within each category.
Lee wrote:
Hi,
I have a little difficulty in achieving a simple result.
I have records that contain numerical data.
For example a client name, list of numbers that relate to , say
performance for a specific category.
So I would have (John, 5, 4, 5, 4, 4 totaling 22 in category Blue)
I also have many other clients scoring in a range of other categories
as well as Blue with similar data.
I'm trying to create a summary that will list each category with the
highest performing client and their total for each category in order
of attainment.
I can get a summary list in many ways but not this specific one
I would like to see
Blue Peter Smith 58
Blue John Brown 56
Blue Paul Simon 53
Red John Dixon 88
Red Brian Brown 82
Red Walter Judd 75
etc
Currently I have two tables, one contains client data and a related
table contains the client ID (link). The scores are entered in the
related table.
Hopefully there is a simple answer.
Lee
--
