SQL Syntax Problem

  • Thread starter Thread starter pc_user
  • Start date Start date
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
 
Try that
strSQL = "(" & gstrDate & " Between #" & Me.BeginningDate & "# And #" &
Me.EndingDate & "#) And ("
strSQL = gstrDate & " Between #" & Me.BeginningDate & "# And #" &
Me.EndingDate & "#)"
 
Back
Top