Add running total() and rownumber() functions to queries and forms
If you are doing any finance related database running totals are an absolutely necessity. At present there is a capacity to do this on reports but not on forms. Workarounds are available but they are clunky and slow the queries down massively on even relatively small datasets.
These functions are available in some SQL implementations and they are long overdue in Jet/Access.
15
votes
Malcolm Bacchus
shared this idea
2 comments
-
James (Russell) Bettridge
commented
This would save me going to Excel to deal with consecutive records. It would not require learning VBA to create my own functions, particularly when the business I work for won't allow VBA because some code could be dangerous. This would round out some functionality for me.
-
This would be a great enhancement.
