Variable in SQL Statement

[Ricky1]

Public Sub LoadStats(Tourney As String, Entry As String, Entrants As String)

rs.Open "Select Count(*) from tblData Where Type = ' &Tourney& ' and Entry = ' &Entry& '"

If Not rs.EOF Then
    Text1.Text = rs.Fields(0).Value
End If

End Sub

i have three variables in my call but i can't seem to write them properly in the SQL box and getting fustrated because its probably simple.