between time

[jerry28ph]

i have a task on between time. I have a table name timelogs and calltime fieldname with data type of date/time which the value is
"03/15/2009 8:45 AM". How can i get the records that called between 8:30 to 9:00 AM only? I tried to apply the command between but there's no record showing. Please help me on this one.
Thanks and i appreciate your help.

Jerry

 

[raskew]

Hi -

You haven't shown us exactly your criteria, but this in the criteria cell of your date field should get it (tested):

Between #3/15/2009 8:30:00 AM# And #3/15/2009 9:00:00 AM#

Bob