>I have a table that has three fields :
>assetid(character), meter(0000.0), mtrdate(DateTime)
>
>How do I base a report that will show me the elasped hours from the lowest meter reading to the highest meter reading for a specific time span?
>
>The time span should work with:
>REPORT ... FOR BETWEEN(mtrdate, {low date}, {high date})
>
>Does anyone have any ideas on the hour meter part?
>
>Thanks
John,
SELECT (MAX(DateTime) - MIN(DateTime)/3600 AS Hours, Assetid ;
FROM Assets ;
WHERE DateTiem BETWEEN( Start,End) ;
GROUP BY Assetid ...