SQL Syntax Problem

P

pc_user

I'm not getting the right syntax and I need help. gstrDate is a global
variable.
=================================
strSQL = gstrDate & " Between #" & Me.BeginningDate & "# And #" &
Me.EndingDate & "# And "
strSQL = gstrDate & " Between " & Me.BeginningDate & " And " &
Me.EndingDate & " And "
=================================
Thanks,
PC
 
O

Ofer

Try that
strSQL = "(" & gstrDate & " Between #" & Me.BeginningDate & "# And #" &
Me.EndingDate & "#) And ("
strSQL = gstrDate & " Between #" & Me.BeginningDate & "# And #" &
Me.EndingDate & "#)"
 
Top