I am trying to write an SQL statement and I can't get the syntax right for it to work. Is there a site that I can learn the SQL syntax? Thanks

Here's the Function:

Public Function GetClient(sClientName As String) As String
Dim sSQL As String
Dim sName As String
sSQL = "SELECT * From Customers " & "WHERE Customers.Contact Name = '" & sClientName & "'"

Set rs = MyDb.OpenRecordse (sSQL,dbOpenDynaset)


rs.Close
End Function

[This message has been edited by bontyboy (edited 02-15-2000).]