checkbook balance

  • Thread starter Thread starter Mick
  • Start date Start date
M

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.
 
Mick said:
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.
Click to expand...

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.
 
Back
Top