I hope I'm not off-list, but can someone help with the following SQL query 
that I'm using in Access and ASP.

The following SQL query does not work:

strSQL= "SELECT * FROM OfficersDirectors WHERE LastName = '" & strLastName 
& " ' " & _
	 " AND FirstName = '" & strFirstName & " ' " & _
	  " AND Position = '" & strPosition & " ' "

However, the following SQL query works fine:

strSQL= "SELECT * FROM OfficersDirectors WHERE LastName = '" & strLastName 
& " ' " & _
	 " AND FirstName = '" & strFirstName & " ' "

What's the difference?

Thanks.

Steve