Join query (i think)

[penguinspeaks]

OK. this is in access DB. I have a table called matches. i have a field
called (username) and a field called (username1) this is where the reports
go to. i have another table called players, that has (username)and total_points field.

what i want to do is this... i want to display a table.. that gets the
username from the 'players' table, and match it up with the info from the
'matches' table.. so the result would show

player wins loses total_games % total_points
----------------------------------------------------
playera 6 4 10 66.6 1524

so basically.. it would count the number of times a name appeared in
the username column as wins, count the number of times the same name
appeared in the username1 column as loses and add the 2 counts together to =
total games... then it would take the wins, and divide by the total_games to
get the %
is this possible?? and does this make sense? or would there be an easier way
to do this in the DB?
Jeff

 

[PHV]

Or this:
, Format(Sum([Win])/Count(*)),"Percent") AS WinPct

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[penguinspeaks]

yes.. both work wonderfully...
thanks for your patience and time... it is most appreciated.
Jeff
bam