[AccessD] Date-scoping

Arthur,

A Guess - Try adding a pair of parentheses:

(TransactionTypeID= 2 AND (TransactionDate BETWEEN #03-Jul-07# AND
#03-Jul-07#))

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, August 29, 2007 7:10 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com