prob with ordening in report...

[Foxie Foxster]

i have two tables
- players (fields playid, name,pts1,pts2,pts3)
- points (field points)

i have to place the sum (total) of points from table points (field points)
into pts3 from players

i made a sum query (two tables into it)

playid name pts3 points
player player player points
group by groupe by groupe by sum
(the query is called qrytotpoints)

and then with a combo box i choose a day of play (from my table dates) and
then in the properties after updating i made this.....


set rspointplay = huidigeDB.opendrecordset("qrytotpoints",dbOpenDyna set)
rspointplay.movefirst
do until rspointsplay.EOF()
repointsplay.edit
rspointsplay!pts3=rspointsplay!sumofpoints
loop
rspointsplayt.close
exit sub
end sub


the debut don't give mistakes and the program don't crash
but.................

in the table players in the field pts3 it stays always ZERO!!!!!!!!!!!!!

question:
why??? (because the query is a sumquery???)
who can give me a way to do it......

reason: i need those three fields to sort all the players in a certain way
thx for your time........
greetings

and yes, i know maybe it's not professional but i'm not and i try to acheive
what i was began in access....

[Pieter Linden]

Umm... this doesn't make sense. I see no reason why you can't create
a query that uses a DSUM function and then update your table with the
result of the DSUM.... Or even just *display* this in your form...

This worked for me...
=DSum("[Points]","tblScores","[UserName] = '" &
Forms!tblUsers!txtUserName & "'")

If you're doing this in a report, is there a reason you can't just use
a totals query?

[Foxie Foxster]

"Pieter Linden" <pi********@hotmail.com> schreef in bericht
news:bf**************************@posting.google.c om...

Umm... this doesn't make sense. I see no reason why you can't create
a query that uses a DSUM function and then update your table with the
result of the DSUM.... Or even just *display* this in your form...

This worked for me...
=DSum("[Points]","tblScores","[UserName] = '" &
Forms!tblUsers!txtUserName & "'")

If you're doing this in a report, is there a reason you can't just use
a totals query?

that doesn't work
gives syntax error

......tbl....ORDER by DSUM("[points]") DESC, ......