I need some help to do a query...Here is what I want. I want to be able to
have all event that is in my database between Monday and Friday, but only
between 4:00pm and 5:00pm at each day(between Monday and Friday).

In my database, I have a field named 'DT', and is type is date/time... And
in all record, this field have it's both part(Date and time). I'am using VB
4.0. I'am not using any SQL server... I'am using the OpenRecordSet method to
run my select Query...

How can I write this query ?

Thanks, for anyone help !

Hi Alexandre,

may try something around:

TimeValue(FieldName) BETWEEN  #4:00 PM# AND #5:00 PM#

Hope it may help,
Vanderghast, Access MVP.