dbTalk Databases Forums  

building query

comp.database.ms-access comp.database.ms-access


Discuss building query in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Foxie Foxster
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.