× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Dear consultants,

the 'problem' is like this:

I use the following files:
SIL
SSM
RCM
IIM

2. Matched records with primary file
ILSAL1 EQ SSAL
ILCUSB EQ CCUST
ILPROD EQ IPROD

Select records:
ILPROD LIKE 'F%'
AND ILDATE GE 20100501
AND ILWHS LIKE 'Q%'
AND SNAME LIKE '%F%'

As output I want to see these fields but than summarized on quantity per
item, while I have more lines for the same item.
10 T01.ILQTY Quantity
20 T02.SSAL Salesman Number
30 T02.SNAME Salesman Name
40 T01.ILCUSB Billing Customer
50 T03.CNME Customer Name
60 T01.ILPROD Item
70 PIECE ilrev/ilqty
80 T04.IDESC Item Description
90 T04.IDSCE Extra Description

The output I want to use in another query.

Thank you very much for your help already!

Rgds,

David AntonissePlease consider the environment before printing this e-mail. --------------------------------------------------------------------------------------------------------------------- Discover Impress on http://www.impressgroup.com The information contained in this e-mail and any attachments is strictly confidential and may be legally privileged.It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee, you are hereby notified that it is prohibited and may be unlawful to disclose, distribute, store, copy the information in any medium or usage for another purpose. ---------------------------------------------------------------------------------------------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.