What's wrong with this sql query which uses a date range?(I'm getting a syntax error)

Hi,

I am using Vb 6 and Access.
I am getting syntax error in the following sql query.

strSql = "SELECT tblInvoice.ProjID,tblInvoice.CusID,tblInvoice.Invo iceNo,tblInvoice.InvDate,tblInvoice.Total,tblInvoi ce.Paid,tblInvoice.Balance,tblCustomer.CustomerNam e FROM tblCustomer RIGHT JOIN tblInvoice ON tblCustomer.CusID=tblInvoice.CusID WHERE tblInvoice.InvDate >= #" &sDate& "# AND tblInvoice.InvDate <= #" &eDate& "# AND tblCustomer.CustomerName='" & cboCustomer.Text & "' AND tblInvoice.ProjID=" & projectID & "AND Balance >0"

Can anyone one point out whats the mistake I am making here?
When I substitute dates instead of the variables, there is no error and the query executes perfectly.

Thanks for ur time.

re: What's wrong with this sql query which uses a date range?(I'm getting a syntax error)

I believe you just need to insert some spaces around the variable names. For example...
Also, just for readability, I would recommend chopping up such long lines. That's why VB has a continuation character (_).

For example, see which of these is easier to see... Oh, by the way. For your date range, you might want to consider using the BETWEEN operator. It makes for more easily readable code.