[AccessD] Date-scoping

I don't use BETWEEN much but technically there's no date between your 2
values when they're the same.  Does it work with =? 


Perry Harold


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, August 29, 2007 3:38 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Date-scoping

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com