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
**********************************************************************
