Sorting Problem

[DES]

I created a Db to keep standings for a Youth Baseball league. Approximately
105 teams spread over 6 age groups.

It works great for entering the game scores. However, it has a problem
sorting the standings.

The standings should be based on Winning Percentage in a descending order.
The report is based of a query that does the calculation based on the number
of wins divided by the number of games.

The Query sorts the Standings correctly, but then the report prints out,
it has problems. problem seems to be at the 2nd decimal point and beyond.

For example the standings might be

Team 1 .950
Team 2 .800
Team 3 .833 <--------
Team 4 .600
Team 5 .550

Etc.

As I said, the Query shows the correct sort.


BTW, Access 2003

Thanks in advance

 

[John Spencer]

Reports IGNORE sorting done by the query.

If you want to sort a report reliably, you must use the Sorting and Grouping
Dialog (Menu: View: Sorting and Grouping) to specify how you want the report
sorted.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[DES]

Thank you for your reply.

I did not know it ignored the Query, but I did try the sorting & grouping
as you suggested.

That does not help.

 

[DES]

The bug gets goofier yet!
The reports sorts first by league U14, U13 etc. The sorts on Winning
Percentage.

I found that when I sort leagues in descending order (i.e. U14 to U9), the
winning % sorts correctly under the U14 league standings but under the 9
year old league standings, screws up.

When I change the league sort to from descending to ascending (U9 to U14),
then the U9 standings are correct and the U14 and wrong!

 

[John Spencer]

I have no idea what is causing the behavior you are seeing. If the sorting
in the query is working and you have the same sorting set up in the report,
I am stumped.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[DES]

Thanks for trying, I appreciate the effort.

I don't feel so dumb now!