This is my SQL im working around for a report:

SELECT "4:30 TO 6:29" AS TimeCalc, Count(*) AS TotalCalls
FROM Msys_obj AS Q
WHERE Q.Time >=#4:30#
AND Q.Time <=#6:29#
UNION
SELECT "6:30 TO 8:29" AS TimeCalc, Count(*) AS TotalCalls
FROM Msys_obj AS Q
WHERE Q.Time >=#6:30#
AND Q.Time <=#8:29#
UNION
SELECT "8:30 TO 10:29" AS TimeCalc, Count(*) AS TotalCalls
FROM Msys_obj AS Q
WHERE Q.Time >=#8:30#
AND Q.Time <=#10:29#
UNION SELECT "10:30 TO 11:30" AS TimeCalc, Count(*) AS TotalCalls
FROM Msys_obj AS Q
WHERE Q.Time >=#10:30#
AND Q.Time <=#11:30#;

The table MSys_obj has a Time column with times recorded between :4:30 and 11:30

On the report, this is one of the text boxes: Calls between 4:30 and 6:29

In the control box I posted this expression: =DCount("=>#4:30#and=<#6:29#)","Time")

When I run the report, I get an #ERROR for the result for Calls between 4:30 and 6:29  

If someone wants to see my Db, let me know and I send it to you.