Results 1 to 3 of 3
  1. #1
    parishpete is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    24

    running total needed against each record in continuous form

    I already have a report which uses running total overall and gives a running total of all records against each record .

    It would be so useful for it to appear when a record is added to the continuous form rather than running the report.

    I can get a full total to appear at the end of the record using

    Private Sub Paid_in_AfterUpdate()
    Dim rst As DAO.Recordset
    Dim Paid_in As Integer
    Dim Money1 As Integer

    Set rst = Me.RecordsetClone

    rst.MoveFirst
    Do Until rst.EOF
    If Not IsNull(rst![Paid_in]) Then
    [Money1] = [Money1] + rst!Paid_in

    End If

    [Total_cash] = [Money1]
    rst.MoveNext
    Loop

    End Sub

    but it's the value of the entire recordset not the total at that point

    [Total_cash needs to catch the value for the recordset up to and including the record any point in the record set.

    Ive tried moving [Total_cash] = [Money1] around but just can't think it through.

    Is there any way of acheiving this?



    All help welcome

    Thanks

    Pete

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe this will help you


    Running Sum in a query
    http://www.rogersaccesslibrary.com/forum/topic279.html

  3. #3
    parishpete is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    24
    Quote Originally Posted by ssanfu View Post
    Maybe this will help you


    Running Sum in a query
    http://www.rogersaccesslibrary.com/forum/topic279.html
    Many thanks will give it a try in the morning.

    Calculation Speed shouldn't be an issue max is about 200 records per query

    regards

    Pete

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

Similar Threads

  1. Replies: 3
    Last Post: 10-19-2012, 04:30 PM
  2. Replies: 3
    Last Post: 10-12-2012, 01:38 PM
  3. Delete continuous form record
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 03-09-2012, 03:00 PM
  4. Hiding a new record in a continuous form
    By system243trd in forum Forms
    Replies: 3
    Last Post: 12-03-2011, 01:04 AM
  5. Get position of record in continuous form
    By Whizbang in forum Forms
    Replies: 3
    Last Post: 11-02-2011, 01:47 PM

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