Parenthesis Help with SQL in VBA

I posted this question here ...but haven't gotten an answer yet. I know cross-posts are frowned upon so sorry guys

http://www.mrexcel.com/forum/excel-q...lications.html


I want to run this statement in VBA (which I know is a valid statement)

''''''Begin & Finish are input boxes that are receiving values as dates...
WHERE tblnew.partName = 'Muffler' AND (tblnew.partEnteredDate Between " & Begin & " And " & Finish & ") 
And tblnew.supervisorCheck IS NOT NULL AND tblnew.OrderDate IS NOT NULL AND tblnew.Ordered IS NOT NULL"

The statement runs fine, but it doesn't return any results and if I run the query in SQL Server it returns results. That being said, I am thinking that I am missing some parenthesis around pieces of the Where clause....can someone assist?

I've answered over there