
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
i have a database with tblplayers tbldate and tblresults i have made a report for result on a date of play and i build a query points solde pointsfavour pointsagainst name date tbkresult tblresult tblresult tblresult tblplayers tbl date desc desc desc desc ascending so the report gives the results and in a way first the points, then the solde, then pointfavour, then pointsagaint, and the name now the problem: is there is equality in points, solde, pointsfavour en poinstagainst the ppl are place alfabetic in ascending..... now i want to get rid of the alfabetic thing but if the points, solde,pointsfavour and pointsagainst are equal i want to place them in order of the poinst become in former playdays....(so following the general classement) i tired to create calculated fields (between points against and name) like this fieldnext:sum[points] but that doesn't work...... can anybody help me how to do this????? thx for your time and sorry if i have explained it too bad to understand greetings
| <-- __Chronological__ --> | <-- __Thread__ --> |