Query in VBA error "between op without and"

[kaledev]

I may be missing something simple, perhaps a fresh pair of eyes will help. I have the following code running a query in VBA

    Else
        strSQL = "SELECT [Q01 Generate Data with Duplicates].[Report Dt], [Q01 Generate Data with Duplicates].Controller, [Q01 Generate Data with Duplicates].Terminal, [Q01 Generate Data with Duplicates].[Eq Init], [Q01 Generate Data with Duplicates].[Equip Nr], [Q01 Generate Data with Duplicates].[Dwell Start Dt], [Q01 Generate Data with Duplicates].[Dwell Start Tm], [Q01 Generate Data with Duplicates].[Dwell Start Event], [Q01 Generate Data with Duplicates].[Dwell Days], [Q01 Generate Data with Duplicates].[Wb Origin], [Q01 Generate Data with Duplicates].[Wb Destination], [Q01 Generate Data with Duplicates].[Wb Route], IIf([outbound billing?] Or [inbound within freedays?],False,True) AS [CY Unit?], IIf((Not IsNull([Wb Origin])) And [Wb Origin]<>[dbo_OLDDATA]!Terminal And [Wb Destination]<>[dbo_OLDDATA]!Terminal,True,False) AS [Outbound Billing?], IIf([Dwell Days]<[Free Days] And [Dwell Start Event]='RMFC',True,False) AS [Inbound Within Freedays?]" _
        & "FROM [Q02 Allotment] INNER JOIN [Q01 Generate Data with Duplicates] ON [Q02 Allotment].TerminalName=[Q01 Generate Data with Duplicates].Terminal" _
        & "WHERE ((([Q01 Generate Data with Duplicates].[Report Dt]) Between CDate(#" & txtReportStartDate & "#) AND CDate(#" & txtReportEndDate & "#)))" _
        & "ORDER BY [Q01 Generate Data with Duplicates].[Report Dt], [Q01 Generate Data with Duplicates].Terminal;"
    End If

When I run it, I recieve the following error:

Run-time error '3075':

Between operator without And in query experssion '[Q02 Allotment].TerminalName=[Q01 Generate Data with Duplicates].TerminalWHERE ((([Q01 Generate Data with Duplicates].[Report Dt]) Between CDate(#2/1/2011#'.

[kaledev]

nevermind, I didn't see that the WHERE clause was missing a space before it. face-palm on that one...