Net.data subtotals -- WEB400

Subject: Net.data subtotals
From: "Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
Date: Wed, 17 Mar 2010 14:23:07 -0500
List-archive: <http://archive.midrange.com/web400>
List-help: <mailto:web400-request@midrange.com?subject=help>
List-id: Web Enabling the AS400 / iSeries <web400.midrange.com>
List-post: <mailto:web400@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=unsubscribe>

It's pretty easy to get this far in net.data with SQL table.

What's the best way to add in subtotals (of 2 columns) at each employee # break?

Badge# Employee Name Begin End Elapsed S.O.# O# Qty Y E CODE Tkt#
876633 AULL, HENRY A. 50022 0.00 68205 10 .000 RUN 0
SUBT SUBT
10721106 FRANZEN, MARLON P. 50048 70355 2.05 68562 10 2.000 RUN 2849329
10721106 FRANZEN, MARLON P. 70355 0.00 68204 10 .000 RUN 0
SUBT SUBT

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the credit." Harry S. Truman

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Net.data subtotals / RUNQRY , Peter Connell

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.