Re: Query/400: Selecting Records based on Record No?

Avron, You can eliminate duplicate records in two steps

Step 1 - Run a query that summarizes all fields in original file and includes 
the Count of the summarized records. Output the summary records to a summary 
file.

Step 2 - Run your report against the summary file. When you do this be sure to 
divide the summarized amounts by the Count so you don't double-up the amounts.

Bob Tenney
Bob Tenney Solutions, LLC
Visit www.tenneypubs.com for books on
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting,
FRx and Presence.


-------Original Message-------
From: avron gershen <aldg3@xxxxxxxxxxx>
Sent: 07/15/03 06:46 PM
To: MapicsML <mapics-l@xxxxxxxxxxxx>
Subject: Query/400: Selecting Records based on Record No?

> 
> Hi group:

I don't believe this can be done but I'll run it by you 
for verification:

If I have a DB file with ten records in it and five of the 
records are duplicated, using Query/400 can I output five 
of the records to a report?  I don't want the duplicated 
records in the report.

I don't see this in the IBM Query/400 Use (Version 3) 
manual.  Did I miss something?

I look forward to your comments.

Regards,
Al Gershen
ECS Composites
Grants Pass, OR
aldg3@xxxxxxxxxxx
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

>