|
Home > Archive > MS Access Multiuser > August 2005 > Query criteria for Date/time is not working
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Query criteria for Date/time is not working
|
|
| Mail Merge Help 2005-08-30, 8:29 pm |
| Hi
In my database, there is a default date field that automatic enter the date
and time when ever there is a changes or new records made to the table.
I created a query from table and with the below criteria.
> [Enter the date]
<[Enter the date].
But it' didn't work
Could some one help me how to defeat this problems.
Thanks
Hong
| |
| Rick B 2005-08-31, 9:30 am |
| Of course this does not work. You are telling it to find all records less
than a date AND greater than the same date. That would never happen. A
record can't be less than January 1st and greater than January 1st.
Why not use...
Between [Enter start date] and [Enter stop date].
--
Rick B
"Mail Merge Help" < MailMergeHelp@discus
sions.microsoft.com> wrote in message
news:09E864CD-B68D-4706-A871- F0F57E780506@microso
ft.com...
> Hi
>
> In my database, there is a default date field that automatic enter the
date
> and time when ever there is a changes or new records made to the table.
>
> I created a query from table and with the below criteria.
> <[Enter the date].
>
> But it' didn't work
>
> Could some one help me how to defeat this problems.
>
> Thanks
> Hong
| |
| Mail Merge Help 2005-08-31, 8:25 pm |
|
Hi Rick
Hi
Thanks for get back to me. What I mean is that I have one criteria >[Enter
date] and another criteria for another query <[Enter Date], they are for a
different query, and I did tried the criteria that you suggested, but it just
didn't work. I think the problem is that it has the time at the end of the
date, eg 29/8/2005 12:20:30 PM. I did try all criteria, even cut short the
time to have it show date only ie 29/8/2005 and apply the criteria >[enter
date].
Thanks
"Rick B" wrote:
> Of course this does not work. You are telling it to find all records less
> than a date AND greater than the same date. That would never happen. A
> record can't be less than January 1st and greater than January 1st.
>
> Why not use...
>
> Between [Enter start date] and [Enter stop date].
>
>
> --
> Rick B
>
>
>
> "Mail Merge Help" < MailMergeHelp@discus
sions.microsoft.com> wrote in message
> news:09E864CD-B68D-4706-A871- F0F57E780506@microso
ft.com...
> date
>
>
>
|
|
|
|
|