Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    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?


    Colin McDonald

  2. #2
    Plutonium Lounger
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts