"Enter Parameter Value" Error In Simple Query (MS Access)

[gamingmouse]

The "game_players" table contains poker data. Each "game_id" is repeated for as many players happened to be in that game, or hand.

If a player saw the flop, then the field "saw_flop_n" = 1; if not, it equals 0. I'm trying to get all game_id in which exactly two players saw the flop:

SELECT Sum(saw_flop_n) AS [num_saw_flop], game_id
FROM game_players
WHERE num_saw_flop = 2
GROUP BY game_id;

But when I run the query above, Access asks me to "Enter Parameter Value" for num_saw_flop. What is wrong with the query above?

Thanks,
gm

 

[PHV]

SELECT Sum(saw_flop_n) AS num_saw_flop, game_id
FROM game_players
GROUP BY game_id
HAVING Sum(saw_flop_n) = 2

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

 

[gamingmouse]

Yes. Thank you.

Also, if I am interested ONLY in games in which I was one of the players, how could I do this?

Each row also has a "player_id" field -- and for each group of "game_id" every "player_id" is unique. The problem is that I cannot simply add

"WHERE player_id = 12"

because player_id is not an aggregate function. Do I have to do a query of a query?