AnsweredAssumed Answered

need to delete oldest invoice for each customer

Question asked by mikesgreenroom on Nov 6, 2008
Latest reply on Nov 12, 2008 by TSGal

Title

need to delete oldest invoice for each customer

Post

Hi all,

 

First post, total newb, thanks in advance for your help and patience

 

I have a file that looks like this when sorted by customer and then date:

 

Customer  date    invoice# amount

andy       1/1/08   333       50.00

andy       2/1/08   453       45.00

bob        1/1/08    152       55.00

bob        1/3/08    256       55.00

bob        1/15/08   301      60.00

 

Is there a script that will delete the first record for each customer (numbers 333 and 152 in this case)? I]m supposed to show a history and total for each customer but the oldest invoice for each customer can't be included in the sum.

 

thanks again

 

mike 

Outcomes