Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate elasped hours from meter readings
Message
From
30/08/1998 20:00:38
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00131371
Message ID:
00131401
Views:
13
>SELECT (MAX(DateTime) - MIN(DateTime)/3600 AS Hours, Assetid ;
> FROM Assets ;
> WHERE DateTiem BETWEEN( Start,End) ;
> GROUP BY Assetid ...

Jim, how can this be so simple<g>??? I thought everything in VFP was complex...

Thanks for the help
Previous
Reply
Map
View

Click here to load this message in the networking platform