Time Query

[benwo]

Hi

I have a DB where I take orders throughout the day and the time is stored in hh:mm:ss format.

Anyone know of a query that I can run that will show me how many oders between certain time? I.e. between 18:00:00 and 18:59:59

Thank you if you can help me!!

Ben

 

[Len Boorman]

think you can use
Between 18:00:00 and 18:59:59

as a criteria in a select query

Try it

Len