Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    8

    Unanswered: Running Totals on a form

    Hi, im having a problem working out a running totals formula. I have a subform running in datasheet view with a total column on it to total up the fee column in my table. i have used the dsum function to total up the fee's but it isnt running, its just the same total in each field (see attached pic). what i would like to do is a total upto the individual record (ie if the first record has a fee of 1 the first total is 1, second fee is 4 then second total is 5, etc) can anyone help?
    Attached Thumbnails Attached Thumbnails Total.JPG  

  2. #2
    Join Date
    Sep 2004
    Location
    Virginia, USA
    Posts
    98
    Can you post all of your code?

  3. #3
    Join Date
    Sep 2004
    Posts
    8
    Private Sub Form_Load()

    Me.TimerInterval = 1000

    End Sub

    Private Sub Form_Timer()

    Total.Text = DSum("[fee]", Form_EditTimesheet.Jbn, "")

    End Sub

    as you can see, im just using the timer function to check the totals with dsum. iv'e left the criteria section of the function blank because i dont know how to set that to each record or even if i can using the dsum function. do you know of a better way of doing this?

  4. #4
    Join Date
    Sep 2004
    Posts
    8
    Any ideas anyone?. Is this actually possible using the dsum function or will i have to go around it another way?

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Dithmo Hi,

    Just so you know, you can't do Totals in a Subform setup as Datasheet. Try changing it to ContinuousForms and place a TextBox in the Footer for running totals.

    have a nice one,
    Bud

  6. #6
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi Dithmo, check this form:

    Bud
    Attached Thumbnails Attached Thumbnails DithmoSampleForm.bmp  

Posting Permissions

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