Use of SQL

 

HI, I would like to do this in an SQL statement: 

 

I want to take a record that has

ACCT  INV#   AMT  TOTAMT

 

Where totamt is created in the SQL

When there is a break, a new ACCT INV.

 

Only when there is a new Acct/Inv then the prev. record should contain
the total of all the prev Acct/Inv Amt's in Totamt.

 

So for example:

Acct   INV     Amt     Totamt

123     001     1.00      0.00

123     001     2.00      0.00.

123     001     3.00      6.00

123     002     1.00      0.00

Etc.

 

Thanks,
Phil

 


This message contains information proprietary to our company. It is intended to 
be read only by the individual or entity named above or their designee.
Any distribution of this message or the information contained herein without 
written permission from our company is strictly prohibited. If the reader of 
this message is not the intended recipient or an agent responsible for 
delivering it to the intended recipient, you are hereby notified that you have 
received this document in error and that any review, dissemination, 
distribution, or copying of this message is strictly prohibited. If you have 
received this communication in error, please notify us immediately by e-mail, 
and delete the original message.