Compare player results

[Andyjones]

I have created a query called test this has all the players name is and results, Im trying to create from this query another query that will allow me to type in two different player names to compare there results. having bit dificulty doing this. see attached. Or would it be better with two seperate querys
Attached File(s) LangleyB_Averages.zip

[recyan]

Hi,

On clicking for the Attached Files, it leads to :
http://www.utteraccess.com/forum/post-a53113-.html
a login password screen.

Is it something like

SELECT 
QRY1.PlayerName, 
QRY1.Results
FROM 
(
SELECT 
Table1.PlayerName,
Table1.Results 
FROM 
Table1
)
AS QRY1
WHERE 
(((QRY1.PlayerName)="A")) OR (((QRY1.PlayerName)="B"));

or something else totally ?

Thanks

[Andyjones]

OK I upload the database

[recyan]

Hi,
Unable to open the db.
If you could upload in .mdb, perhaps more people will be able to take a look at it & help you out.

Thanks