Re: Please help ~ Syntax Error

Tech-Archive recommends: Speed Up your PC by fixing your registry

Not sure where or how you think I can use that. I must be missing
something.


"rayc via AccessMonster.com" <u17875@uwe> wrote in message
news:5bfbf6bc24bb8@xxxxxx
Did you try the CDate() function?


Gina Whipp wrote:
DId that, same error...
Even changed them all to Date/Time fields and put back the #'s, same
error.
The only time the error stops, see below, but then the report doesn't
filter.

Perhaps my problem is my approach? I have an unbound form that when
opened
the report opens showing all of it's records. The you make a selection on
the form press the Filter button and it's suppose to requery the report
and
show the the new results. This silly form works on ALL my other reports
that don't use Between. It was when I wanted to say Between these 2 dates
that I can't seem to get it right.

So perhaps I should try another approach, maybe my unbound form wasn't
meant
to handle Between?

Take out the #. It is only for date/time fields. For text fields you
need
[quoted text clipped - 52 lines]
Thanks,
Gina

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200602/1


.

Quantcast