[AccessD] Date-scoping

Does the transaction date include the time?

If so, you need to make it midnight so you
match the range you are giving it. With no
time specified in your range, it is looking
for only midnight.

Robert

At 04:32 AM 8/29/2007, you wrote:
>Date: Wed, 29 Aug 2007 03:38:05 -0400
>From: "Arthur Fuller" <fuller.artful at gmail.com>
>Subject: [AccessD] Date-scoping
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <29f585dd0708290038q70225123v23b00e4bbacdab3b at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>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?
>
>TIA,
>Arthur