Results 1 to 4 of 4
  1. #1
    Cheryl R is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Posts
    36

    Running Sum Property Missing

    I have a form with a subform. I am trying to add a running sum to the subform list. Simple, right?
    I added a text box to the subform, made the Control Source =1.


    (I am making the changes via the actual subform rather than going through the main form.)
    Theoretically, there is supposed to be an item on the Properties Data Tab that says RunningSum.
    However, this is not an option with mine (am running Access 2010).
    What am I doing wrong?
    Click image for larger version. 

Name:	RunningSumMissing.JPG 
Views:	11 
Size:	16.6 KB 
ID:	12578

  2. #2
    Cheryl R is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Posts
    36
    DUH- Sorry, silly question - That function is only available in reports (time to get my head out of my access- har har)
    Though I'm sure there is a way to do this on the form...

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Here are two articles on creating running sums on forms. I googled "msaccess running sum in form"

    http://www.tek-tips.com/faqs.cfm?fid=5248
    http://support.microsoft.com/kb/210338

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    And another you might find interesting http://allenbrowne.com/subquery-01.html#YTD
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running queries, VIA VB, but not running in Order
    By mike02 in forum Programming
    Replies: 6
    Last Post: 06-01-2013, 07:07 AM
  2. Global Property Changes
    By ajetrumpet in forum Code Repository
    Replies: 2
    Last Post: 08-07-2012, 10:31 PM
  3. Missing references and running code at startup
    By springrider in forum Programming
    Replies: 1
    Last Post: 01-09-2011, 09:47 PM
  4. Create Property
    By RAPSR in forum Programming
    Replies: 2
    Last Post: 10-12-2010, 12:39 AM
  5. Can Grow Property
    By MFeightner in forum Reports
    Replies: 0
    Last Post: 06-24-2009, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums