Sorry for the OT but I'm at a loss on this one.
I've built an application for a Fire/Rescue service to log their calls,
meeting attendance, etc. (geared to small, volunteer agencies). One of the
things that's very important for them is a sum of the hours spent on calls.
Each call record has a uniquely generated call number that is the year
followed by a hyphen and a three digit incrementing number. Each record also
has times for various events from dispatch to return to quarters. The times
are in short time (17:34) format. It's an Access database, it's all they can
afford/support right now.
I need to get a sum of the difference between dispatch time and return to
quarters time for all calls in a given year.
I've tried what seems to me to be the obvious:
SELECT SUM(DateDiff("h",DISPATCH_TIME,RTN_QTRS)) AS SUMHRS
FROM t_Calls
WHERE CALL_NO LIKE '2001-*-';
But that hasn't worked. I've played around with a number of other options
but haven't gotten anything to work. I'd appreciate any help anyone here can
provide.
Thanks,
Scott
Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North Prairie, WI 53153-0235
Phone: 262.392.9173
Fax: 262.392.9174
Toll Free: 888.821.3427
Mobile: 262.490.1376
<http://www.prairiesoftdev.com>
Amateurs practice until they get it right,
Experts practice until they can't get it wrong.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
