Filtering time

[Coors]

I have a column that gives the time of an operation ie. "5:06:50 AM" All the data is based on a 12 hour clock (not military time)

In the Criteria: area how do I sort between 5am-5pm? I tried "Between 5:00:00AM and 5:00:00PM", but it did like it

Thanks,

[boblarson]

It has to have the octothorpes (#) too:

Between #5:00:00 AM# And #5:00:00 PM#

[June7]

Assumes field is date datatype. Text type won't work.

Octothorpes - that certainly expands my vocabulary!

[Coors]

It has to have the octothorpes (#) too:

Between #5:00:00 AM# And #5:00:00 PM#

Worked great, Thanks.