How do I sort on a calculated field in a report in Access 97

[HELENO]

Hi,
I am designing a report for a world cup fantasy team competition that I have created in Access 97.

Each entrant must pick 11 players, who can earn points, and i need the sum of all these points represented in a leader board report.

I can create each individual's scores, but for some reason, the report won't sort itself by that field. I have changed the sorting/grouping, but it still won't work.

thanks,
Helen

[jimatqsi]

Probably you need to change the query the report is based on. I suspect your query is returning each individual score. What you really want is for the query to sum the scores and group by entrant; so the report will receive 1 row for each entrant, not 11 rows for each entrant.

So after changing the query you will also have to change the binding of the score text box; now it is probably bound to a field named something like "score" and that will not be available anymore, it will be "SumOfScore " instead.

Hope that helps.

Jim