Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

building query



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__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.