[SPAM] - last line only - Sender is forged (SPF Fail)

[Pickering, John (NORBORD)]

Add "at CustNum" to the SET SUBFILE statement, as in ...
 
>set subfile name actlst1 at CustNum noappend
 
 
 
-----Original Message-----
From: Dwight Schenk [mailto:dschenk at thalesnavigation.com]
Sent: Monday, December 19, 2005 4:11 PM
To: powerh-l at lists.sowder.com
Subject: [SPAM] - last line only - Sender is forged (SPF Fail)



I need to get a subfile  that will only contain the last line for each
report group.

 

The report group consist of Customer number with several locations I want to
count up the locations and report how many locations each customer has on
one line in a subfile.

 

This is what I have so far:

 

Access CustFile link CustNum to CustNum of Locations

 

Define kount num*8 = 1

 

Sort on CustNum  on location 

 

Report summary CustNo at CustNo kount subtotal reset at CustNo

 

Set subfile name actlst1 noappend

 

The output:

Cust_no            Kount

10000               1

10000               2

10001               1

10001               2

10001               3

....

 

I just want the last line for each customer.

 

 

Thanks,

Dwight

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051219/e976e744/attachment.htm