Date/Time query

[Stacey]

Hi.

I have a query built against a liinked table. The Date field on the table is Date/Time and I cannot change it. I want to allow the user to type in a date and have all records from that date show up regardless of the time. I have searched the forum for questions and I did find one that said to insert a new field, DateValue([RELEASE_DATE]), and use Date() as the criteria. I am getting a date type mismatch message when I do this. Also, I want the user to be able to type in the date they need, instead of having it use the current date.

Is there any way to do what I want? Right now, I have it set up with a start date (they enter 05/25/2004 6:00:00 am, for example) and an end date (05/25/2004 11:59:59 pm). This is a pain.

Any help would be greatly appreciated.

Thanks
Stacey

 

[pdx_man]

Hmmm ... how about this. I am assuming a parameter query. Have the user enter 05/25/2004. Your criteria would be:

>=[Enter Your Date] And < Dateadd("d",1,[Enter Your Date])

 

[Stacey]

That did the trick...thank you so much!

Stacey