Access to Excel combining criteria

[Guest]

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%""))"

 

[Rob van Gelder]

instead of a comma, try AND
eg.
select * from table where DOB >= 1-Jan-1990 AND lname like 'B%'

 

[Guest]

Thanks That works

instead of a comma, try AND
eg.
select * from table where DOB >= 1-Jan-1990 AND lname like 'B%'