H
Harvey
Hi, can anyone help with a problem I have?
I have a report that I want to sort on an expression.
Here is an example of what I have. I have got three
fields, which are,
Name Homescore Awayscore
Name1 21 11
21 16
17 21
Total 59 38 average 1.552
Name2 21 12
21 15
21 18
Total 63 45 average 1.4
The report as a name header & name footer and the header
is grouped on the name field. The footer has three text
boxes, one sums the homescore, one to sum the awayscore &
one called average which divides homscoreby awayscore.
This works well. My problem is that I want to sort on the
average text box.
Thanks harvey
I have a report that I want to sort on an expression.
Here is an example of what I have. I have got three
fields, which are,
Name Homescore Awayscore
Name1 21 11
21 16
17 21
Total 59 38 average 1.552
Name2 21 12
21 15
21 18
Total 63 45 average 1.4
The report as a name header & name footer and the header
is grouped on the name field. The footer has three text
boxes, one sums the homescore, one to sum the awayscore &
one called average which divides homscoreby awayscore.
This works well. My problem is that I want to sort on the
average text box.
Thanks harvey