Re: Please help ~ Syntax Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Nope that didn't work either, didn't think it would because date field is
actually formated as text. Now error reads:

Syntax error (missing operator) in query expression '(Between #9/8/2004# And
#9/9/2005#)'.



"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DCCA6F27-F87C-4A6E-BFD4-65803F38B128@xxxxxxxxxxxxxxxx
Dates need to be enclosed in #, Without being able to test this, I can't
guarantee it, but try this:

If Me("Filter1") <> "" Then
strSql = strSql & "Between #" & Me("Filter1") & "# And #" & _
Me("Filter2") & "# And "
End If


"Gina Whipp" wrote:

Hi All,

Thanks in advance...

Here's my line:


If Me("Filter1") <> "" Then
strSql = strSql & "Between " & Me("Filter1") & " And " &
Me("Filter2") & Chr(34) & " And "
End If

Here's my error:

Syntax error (missing operator) in query expression '(Between 9/8/2004
And
9/9/2005")'.

What am I missing?

Thanks,
Gina





.