Пременная и запрос

[Mckoy]

Помогите найти ошибку в запросе.

Код: Выделить всё

Player = InputBox("", "Enter Player Nick")
Set rs = db.Execute("SELECT game_players.real_player_id AS PID " & _
"FROM players INNER JOIN game_players ON players.player_id = game_players.player_id " & _
"Where (((players.screen_name) =  "" & Player & "")) " & _
"GROUP BY game_players.real_player_id;")
MsgBox rs.Fields("PID")

По разному пробовал, выдает разные ошибки. В общем запрос работает в таком виде

Код: Выделить всё

'Player = InputBox("", "Enter Player Nick")
Set rs = db.Execute("SELECT game_players.real_player_id AS PID " & _
"FROM players INNER JOIN game_players ON players.player_id = game_players.player_id " & _
"Where (((players.screen_name) =  ""Scrolt3"")) " & _
"GROUP BY game_players.real_player_id;")
MsgBox rs.Fields("PID")

Никак не хочет в первый запрос вставить текстовую переменную. Что тут с синтаксисом? Я не профи, подскажите

[Konst_One]

Код: Выделить всё

Player = InputBox("", "Enter Player Nick")
Set rs = db.Execute("SELECT game_players.real_player_id AS PID " & _
"FROM players INNER JOIN game_players ON players.player_id = game_players.player_id " & _
"Where (((players.screen_name) =  """ & Player & """)) " & _
"GROUP BY game_players.real_player_id;")

" заменять надо на ""

[Mckoy]

Большое Спасибо Все заработало