Results 1 to 2 of 2
Thread: Running Sum (Access 2000)
2001-09-17, 15:30 #1
- Join Date
- Jun 2001
- Edinburgh, Midlothian, Scotland
- Thanked 0 Times in 0 Posts
Running Sum (Access 2000)
Is it possible to create a running sum in a form.
I have a module which needs to display bank account information if the expected total does not match a bank statement. I then need to look through the various entries to find the error (small number of entries, so easy task).
I started using a report which I opened in Preview mode. But as I need to take different actions depending on what I find, I need a msg box after I'm finished. If I place this in the module, then I cannot halt execution of the module till I have found an error. The msgbox therefore opens, and takes the focus, and I can't use the form.
I next tried a form which I can open in Modal property set to yes. This lets me check my statement for as long as I want, but I can't find an obvious way to create a running sum. Obviously, I don't want to store the balance, as it should be a calculated field, but I can't see a way to do it.
All I want is a count on a currency field called [PayDepAmount]. Alternatively is there a way to give the report preview the focus while I investigate?
Can anyone help?
2001-09-17, 16:29 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Running Sum (Access 2000)
You can't really create a running sum on a form, but you can create a calculated value. Look up the DSum() function in on-line help.Charlotte