what are some good resources for learning SQL query syntax? I can do simple ones, but the following problem has perplexed me.

I want to create or filter a recordset based on a combobox selection, but the combobox selection is made up of FirstName and LastName, which are separate fields in the database. How can I say "WHERE FirstName & LastName = 'cboName.text'"? Is this possible?