I have a table with dates in the format of "8/1/2004 16:56:21 PM" and I am having great difficulty simply running a "between" dates query.
Initially, I had it set up as: between [enter beginning date] and [enter end date]. This skips some records. If I manually put ">=#8/1/2004# and <=#9/16/2004#" it will work perfectly. Problem is, I need to allow the user to enter the range. I've tried every combo I can think of, including:
"Between [enter beg date] & " 00:00:00 AM" and [enter end date] & " 23:59:59 PM" and it will not work-- it will continue to skip records between 9/2 and 9/9. The dates are all coming from the same table, and they are formatted identically.
I've spent a good 7+ hours trying to figure this out, and I'm about ready to throw in the towel. I'm just too frustrated. I'll keep checking back to see if you can recommend anything. Thanks...
Initially, I had it set up as: between [enter beginning date] and [enter end date]. This skips some records. If I manually put ">=#8/1/2004# and <=#9/16/2004#" it will work perfectly. Problem is, I need to allow the user to enter the range. I've tried every combo I can think of, including:
"Between [enter beg date] & " 00:00:00 AM" and [enter end date] & " 23:59:59 PM" and it will not work-- it will continue to skip records between 9/2 and 9/9. The dates are all coming from the same table, and they are formatted identically.
I've spent a good 7+ hours trying to figure this out, and I'm about ready to throw in the towel. I'm just too frustrated. I'll keep checking back to see if you can recommend anything. Thanks...