× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: IBM's Query (WRKQRY)
  • From: Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>
  • Date: Fri, 18 Feb 2000 08:08:36 -0500

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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.