Group statement not working

[Mhypertext]

I am using this statement
SELECT player_id,SUM (Pointsearned) FROM vgttotals
GROUP BY Player_id

when i hit run it asks for a parameter value then i put in 1 and the query shows

1 row and 2 columns what am i doing wrong?

 

[ByteMyzer]

What parameter value does it ask for?

 

[Mhypertext]

it asks for player_id value

which is set as a number and general

 

[ByteMyzer]

it asks for player_id value

which is set as a number and general

That indicates that player_id is not a valid field name in table vgttotals, so the query assumes that player_id is an input parameter. You will need to replace this with the actual field name.