469,159 Members | 1,482 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

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

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.

Jun 8 '10 #1
1 1881
1,258 Expert 1GB
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.

Jun 10 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Frankie via AccessMonster.com | last post: by
2 posts views Thread by John | last post: by
3 posts views Thread by kelley.l.turner | last post: by
1 post views Thread by Nelly | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.