Hi Everyone!

I'm having a trouble with this line of code.

Rs.Open "SELECT * FROM Table WHERE Fname LIKE '%" & txtFname.Text & "%'" & " AND AVGRANK BETWEEN #1# AND #2#", con, adOpenDynamic, adLockOptimistic

How can i merge the 2?

I'm getting a syntax error in date in query expression.

Can somebody point me to the right direction?

TIA.