Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: DSUM need help...

    Hi all,

    I'm trying to do a running sum of a column using DSUM function. Unfortunately, it doesnt give the answer that i want.

    I have a table with 4 fields -> [OrderID], [Date], [Customer], [Amount].

    And i'm trying to display the running sum of [Amount] field. So, i created a form n use the DSUM function. But instead of getting a line-by-line running sum, i get a line-by-line Grant Total of [Amount]

    The formula i used is DSUM("[Amount]","QueryName").

    Please HELP!!!!!!!!!!


  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    dsum is doing it's job correctly.

    you could try
    for a running sum discussion

    currently using SS 2008R2

Posting Permissions

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