[AccessD] Date-scoping

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?