Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select and sum
Message
 
 
To
22/06/2005 07:37:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01024603
Message ID:
01025384
Views:
13
Add 2 more columns to the query
...
SUM(IIF(typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_m, ;
SUM(IIF(typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000) AS tot_a ;
...
After that you can create report variables for tot_m and tot_a in the and with calculation as SUM. You can reference those variables wrapped in Sec2str() in the fields in the summary band.


>I'm sorry to bother you
>I try to do it at my self, I fail
> This code under it works,

<snip>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform