[AccessD] Date-scoping

Mark A Matte markamatte at hotmail.com
Wed Aug 29 09:23:32 CDT 2007


I think in using docmd.openreport where condition...your criteria should be 
in quotes.

Good luck,

Mark A. Matte

>From: "Dan Waters" <dwaters at usinternet.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Date-scoping
>Date: Wed, 29 Aug 2007 07:34:15 -0500
>
>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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Puzzles, trivia teasers, word scrambles and more. Play for your chance to 
win! http://club.live.com/home.aspx?icid=CLUB_hotmailtextlink




More information about the AccessD mailing list