AS/400 Field totals

5 pts.
Tags:
AS/400
I'm trying to run a query where I get the separate total for several fields in a table. I need a return with the individual totals for each field. I'm using the AS/400
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • pdraebel
    On the Define Query display 2 options for defining totals are present: "Select report summary functions" and "Define Report Breaks". These should help you get the results you want.
    7,545 pointsBadges:
    report
  • ToddN2000
    What type of totals are you looking for? Sub total or totals based on data in the line? You may need to define a new field with you calculation or ad sub totals using the the method mentioned by pdraebel. Are you trying to do this with WRKQRY, WRKQMQRY or SQL?
    131,645 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: