RecordSet for a Table

[miguel vasquez]

Can anyone help me to create an accumulative balance in a table if the invoice is the same. For example:

Inv # Transaction Amount Balance
123456 10 10
123456 20 30
123456 15 45
321654 10 10
321654 35 45
321654 10 55

Thanks

 

[miguel vasquez]

Hi Roger,

This is fantastic!!!

Thanks a million!!!

Try this example from Roger.

Rogers Access Library --- Excellent compendium of Access 2000 routines from Roger Carlson.