Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Bristol, England
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating a rolling yearly sum (Access 97)

    Hi Hoping someone may be able to help with this query. I currently have a query set up to look at number of orders made per month, what i need to do is add another column to calculate for each month the sum of the previous 12 months orders. Is this some how possible?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating a rolling yearly sum (Access 97)

    Just a thought here...
    You could create a report of this data and group by the month field using the report wizard...then on the month field choose the sorting and grouping icon in design view of your report and be sure that group = month above and on the line that says group footer = no below make it say yes...
    Then add up your totals column with a text box from the toolbox toolbar, and type something in sort of like this:

    =SUM([fldName]) Where fldname is your total column that you add up

    and then you can even copy that into a report footer area and you will have a grand total at the end of your report

    Good luck
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Location
    Bristol, England
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating a rolling yearly sum (Access 97)

    Thanks i shall give that a go and see if it produces what i need

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating a rolling yearly sum (Access 97)

    Whoops I forgot something...You can also double-click on the formula of:

    =Sum([fldtoAdd])

    And in the properties sheet, choose the ALL tab and choose the Running SUM line, and say "Over Group" or "Over All" whatever serves your Rolling sum needs.

    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculating a rolling yearly sum (Access 97)

    This can probably be done in a query, but you will need to tell us a bit more about your query; perhaps you can post the SQL for the query (select View | SQL, and copy the SQL statement to the clipboard, then paste it into a reply.)

Posting Permissions

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