running balance in each record

[b77ar]

Is it possible to get the running balance in each record for each Account ???
i have tried to do it in a query using the DSum() method , but i can not may be becouse i have many account !!!!
Thanks in advance for your help.

 

[Scooterbug]

From what I've seen, you have other issues to work on first. For starters, having a lookup field at the table level is a bad idea. A quick search of the forums for table lookup will net you why.

Second, when I attempted to open up the form, it prompted me for a value for the query for your subform. When I clicked OK without entering any data, the subform refused to open and it threw up an error.