[AccessD] Date-scoping

Arthur Fuller fuller.artful at gmail.com
Wed Aug 29 02:38:05 CDT 2007


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



More information about the AccessD mailing list