RecordSet for a Table (1 Viewer)

[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

 

[Uncle Gizmo]

Running sum in query

Try this example from Roger.

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

 

[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.