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

[lucas Geheniau <geheniau@xxxxxxxxxxxxxxxxxx>]

Hi Al,

Give a break at the key field, then select summary instead of detail.  For 
the fields you want to display, select minimum.(or maximum)
That will do.(I hope)

Greetings from very warm Netherlands( 35 Celcius we have only once in ten 
years)

Lucas



At 18:46 15-07-03 -0400, you wrote:
> 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.

www.viva-lancia.com
Best Regards,
                Lucas

A good player makes himself look good;
a great player makes the team look good.

L. Geheniau                                     M.I.S. supervisor / 
Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@xxxxxxxxxxxxxxxxxx
        l.geheniau@xxxxxxxxx
sms: No phone!  0615026840