need Help with multiple sql criteria (1 Viewer)

[Rand]

combo 86 is text and i keep getting an error see attached image
the numbers are date serial numbers. it works if i dont use the combo86 clause
the syntax is as follows:
strSQL = "SELECT Qry_CalDataBS.dte,Qry_CalDataBS.bs "
strSQL = strSQL & "FROM Qry_CalDataBS "
strSQL = strSQL & "WHERE Qry_CalDataBS.bs = '" & Me.[Combo86] & "' "
strSQL = strSQL & "WHERE (Qry_CalDataBS.dte) Between " & lngFirstOfMonth & " And " & lngLastOfMonth & " ORDER BY "
strSQL = strSQL & "Qry_CalDataBS.dte;"

it is from a populated calendar i got somewhere and trying to modifyy it to show just certain records based on the combo 86 dropdown.
tnx

 

[pbaldy]

You can only have one WHERE clause, but it can have multiple criteria separated by AND or OR.