Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: Keeping a running total

    In a form I'll call 'Form1', I have a field called 'Cost'. What I would like to do is on exiting the 'Cost' field I would like an unbound box called 'Total' to show the Total of all entries in the table 'Table1' labled 'Cost'. Basicly keeping a running total of all 'Cost' entered into the DB.

    If anyone can help, thanks in advance.

    Bob G7

    P.S. Access 2000 if that helps.

  2. #2
    Join Date
    Jun 2004
    Posts
    92
    Use, total = DSum("[cost]", "table1") in whatever event you want such as "on lost focus."

  3. #3
    Join Date
    Mar 2004
    Posts
    18

    Thumbs up It Worked

    Thank you, that did just what I needed it to do.

Posting Permissions

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