Syntax Headaches

[Rjc8513]

Can Between...And be used in a VBA SQL statement? I can't seem to find any reference in the Help files and can't get the syntax correct when trying to write it in VBA.

dbs.CreateQueryDef "qry- EMF ARCHIVE", _
"SELECT * FROM [qry- EMF DATA] " _
"WHERE [YRPP] Between " & BegYRPP & " And " &
EndYRPP & ";"

BegYRPP and EndYRPP are variables.

Thanks.

 

[JeremyNYC]

Yep.

If you're having trouble with that particular statement, you should add # signs before and after each of the variables (assuming they're dates).

dbs.CreateQueryDef "qry- EMF ARCHIVE", _
"SELECT * FROM [qry- EMF DATA] " _
"WHERE [YRPP] Between #" & BegYRPP & "# And #" &
EndYRPP & "#;"

They work like single quotes do for text variables.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.