[AccessD] Date-scoping

I'm passing it as the criteria string to a docmd.openreport. Thanks for
looking at it. I'll keeping flailing about and see what happens. :)

On 8/29/07, Susan Harkins <ssharkins at gmail.com> wrote:
>
> Well, it looks Okay Arthur -- what's happening, is it returning incorrect
> dates, no dates, or an error? How are you passing this search string?
>
> Susan H.
>
> It's been a long while since I've done an MDB-BE and it's amazing how much
> one forgets. I'm trying to date-scope a report. I've got a little form
> that
> asks for start and end dates, and the result is being passed in like this:
>
> (TransactionTypeID= 2 AND TransactionDate BETWEEN #03-Jul-07# AND
> #03-Jul-07#)
>
> This is not working. What am I doing wrong?
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>