|
You might want to consider IBM's Query Management. If you have a 400, you have it. If you have SQL, you have a prompter for it. Query Management can do selections based on control breaks by using SQL's GROUP BY and HAVING clause. You do lose the detail lines however. aleisk@frpaper.com on 02/17/2000 01:25:27 PM Please respond to MIDRANGE-L@midrange.com@Internet To: MIDRANGE-L@midrange.com@Internet cc: bblount@anchorfoods.com@Internet Fax to: Subject: IBM's Query (WRKQRY) > 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. >
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"> <TITLE>IBM's Query (WRKQRY)</TITLE> </HEAD> <BODY> <BR> <P><FONT SIZE=2 FACE="Arial">When using the count capability in query, I need to use this field in a</FONT> <BR><FONT SIZE=2 FACE="Arial">calculation at level break time. What do they call the field?</FONT> <BR><FONT SIZE=2 FACE="Arial">When using totaling, they use the field name they are totaling with 01 on</FONT> <BR><FONT SIZE=2 FACE="Arial">the end. I've tried everytning I could think of with no luck.</FONT> </P> </BODY> </HTML>
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
