checkbook balance

[Mick]

I'm creating a checkbook program. The check register form
is bound to a query, and I'm using a Dsum function in the
form to obtain a running balance. The problem is, of
course, that it is SLOW. (I've had to include so many
criteria to account for late or out of order entries.)
I'm sure there must be a way either in the query or in a
module to get a running balance in a much more efficient
way. Any suggestions would be appreciated.

 

[Mike Painter]

I'm creating a checkbook program. The check register form
is bound to a query, and I'm using a Dsum function in the
form to obtain a running balance. The problem is, of
course, that it is SLOW. (I've had to include so many
criteria to account for late or out of order entries.)
I'm sure there must be a way either in the query or in a
module to get a running balance in a much more efficient
way. Any suggestions would be appreciated.

None of the dSomething functions are very fast and I think MSFT should
replace them with bootstrapped functions built on queries. (I'm lazy)
If you build a query based on your criteria it will run much faster.
Databases tend to not do well with running sums. I'd buy an old copy of
Quicken.