RE: IBM's Query (WRKQRY)

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

You have stumbled upon what I consider the greatest short comming of
AS/400 query.  You can not do total time calculations.  I could be
wrong, but think you can do subtotal calculations with query manager.
Bill Erhardt

> -----Original Message-----
> From: Kirk Yates [SMTP:kirk.yates@usa.net]
> Sent: Thursday, February 17, 2000 2:02 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: IBM's Query (WRKQRY)
> 
> "Leisk, Andrew" wrote: 
> 
>         
> 
>       When using the count capability in query, I need to use this
> field in a 
>       calculation at level break time.  What do they call the field? 
>       When using totaling, they use the field name they are totaling
> with 01 on 
>       the end.  I've tried everytning I could think of with no luck.
> 
> 
> Try adding an "05" to the field name. 
> 
> Total - 01 
> Average - 02 
> Minimum - 03 
> Maximum - 04 
> Count - 05 
> 
> -- 
> Kirk Yates 
> Director of Data Processing 
> Rockwood School District 
>  


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---