Mbowe
Programmer
- Jan 6, 2006
- 35
Hi! Can anyone help me with this? I would like to select the data where criteria is between 01/01/2006 and 12/31/2006, for some reasons it selects everything, seems criteria not to be working.
This is the criteria:
Between "1/1/2006" AND "12/31/2006"
I also tried:
Between #1/1/2006# AND #12/31/2006# which did not select any record at all.
But if I try ="12/31/2006" then works fine. Where am I doing wrong?
Thanks.
This is the criteria:
Between "1/1/2006" AND "12/31/2006"
I also tried:
Between #1/1/2006# AND #12/31/2006# which did not select any record at all.
But if I try ="12/31/2006" then works fine. Where am I doing wrong?
Thanks.