Query criteria for Date/time is not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mail Merge Help - 31 Aug 2005 00:32 GMT

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

Reply to this Message

Rick B - 31 Aug 2005 14:10 GMT

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].

Signature

Rick B

> Hi
>
[quoted text clipped - 11 lines]
> Thanks
> Hong

Reply to this Message

Mail Merge Help - 31 Aug 2005 23:48 GMT

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

> 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
[quoted text clipped - 20 lines]
> > Thanks
> > Hong

Reply to this Message