Using between and operators in OpenRecordSet

L

Luc

I'm trying to use the between and operators
in a recordset like this:

Set rstin = dbs.OpenRecordset("Select * From
tblTenantsinSplit Where StartDate Between #" & varDateBeg
& "# And #" & varDateEnd & "# _
Or EndDate Between #" & varDateBeg & "# And #" &
varDateEnd & "#")

For some reasom I get a syntax error.
Does anyone see any reason why i'm getting this error?
TIA.
 
B

Brendan Reynolds

Your line-continuation is inside the string. Try changing ...

& "# And #" & varDateEnd & "# _

.... to ...
& "# And #" & varDateEnd & _
"# Or etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

openrecordset with several date ranges 2
Between And in SQL Statement 3
working with date ranges in recordset 2
MS Word Page Layout/Break/Margin Issues, help 0
Openrecordset with date criteria 1
Help with Code and Working Days including Holidays 14
Parameter Query 2
Data type mismatch in criteria expression 4

Top