building query -
12-02-2003
, 06:51 AM
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 |