Time

[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

 

[selenau837]

Why not create a query that does exactly what you just stated. Make the criteria BETWEEN 18:00 and 19:00. If you want to include the 18:59, then use the 19:00. I may be wrong on that, but I am sure the BETWEEN works in the criteria.