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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HELENO
    New Member
    • Jun 2010
    • 1

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

    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
    Moderator Top Contributor
    • Oct 2006
    • 1293

    #2
    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

    Comment

    Working...