I have dates in the format of "8/2/2004 10:51 PM" in my tables. I would simply like to allow the user to input two dates, and be able to pull all records within the date range. Here's the odd thing: using "Between [enter beg date] and [enter end date]" does not work. For some reason, it works when I input ">=8/2/2004 and <=9/14/2004"
Is there a way to do this better, or to add the wildcards (>=/<=) to my query? I tried "Between "<=" & [enter beg date] and "<=" & [enter end date]" to no avail.
Thanks--I will be watching for responses!
Is there a way to do this better, or to add the wildcards (>=/<=) to my query? I tried "Between "<=" & [enter beg date] and "<=" & [enter end date]" to no avail.
Thanks--I will be watching for responses!