Hi Lee,
try exporting the results to a new table and do the sort and report
from that table.
On Dec 6, 2008, at 4:27 PM, Lee wrote:
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
--
Ralph
