I use this in an Access DB that is linked via ODBC.

SELECT Sum([SUMMARY-NYC].BYTES) AS SumOfBYTES, [SUMMARY-NYC].ENTITY,
First([SUMMARY-NYC].ADDRESS) AS FirstOfADDRESS, Sum([SUMMARY-NYC].FAILED) AS
SumOfFAILED, Min([SUMMARY-NYC].START_TIME) AS MinOfSTART_TIME,
Max([SUMMARY-NYC].END_TIME) AS MaxOfEND_TIME
FROM [SUMMARY-NYC]
WHERE ((([SUMMARY-NYC].ACTIVITY)="BACKUP") AND
(([SUMMARY-NYC].START_TIME)>=DateValue(Now()-1) & Space(1) &
TimeSerial(16,0,0)) AND (([SUMMARY-NYC].END_TIME)<=DateValue(Now()) &
Space(1) & TimeSerial(16,0,0)))
GROUP BY [SUMMARY-NYC].ENTITY;


**********************************************************************
This message, including any attachments, contains confidential information 
intended for a specific individual and purpose, and is protected by law.  If 
you are not the intended recipient, please contact sender immediately by reply 
e-mail and destroy all copies.  You are hereby notified that any disclosure, 
copying, or distribution of this message, or the taking of any action based on 
it, is strictly prohibited.
TIAA-CREF
**********************************************************************