Query for after hours and weekends

[desireemm1]

is there a way to setup a query that will show data for after hours and weekends? How would I create a query that would show you how many hang-ups and voice messages happened after hours.



hours of operation are 6:00 AM - 4:30 PM would have to do this on the [Date & Time Left] field. ( this isn't my database, I was just told to create some reports on it)

SELECT [Message Tracking].[Date & Time Left], [Message Tracking].[Date Returned], [Message Tracking].[Customer Type]
 FROM [Message Tracking

[ranman256]

In the query time field :
format([datefield],"hh:nn ampm") between #4:30 PM# and #5:59 am#