Using xl2000, Access 2000 with ADO query
The first 2 sql statements work, but I cant seem to get the syntax to
combine them as in #3 below.
Any help?
thanks

sql = "Select " & sFields & _
" From " & sTable & _
" WHERE (((DOB) = #1/1/90#))"

sql = "Select " & sFields & _
" From " & sTable & _
" WHERE (((Lname)Like""B%""))"

sql = "Select " & sFields & _
" From " & sTable & _
" WHERE (((DOB) = #1/1/90#), ((Lname)Like""B%""))"