last line only

[Dwight Schenk]

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/53572967/attachment.html