Results 1 to 2 of 2
  1. #1
    cap.zadi is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    Cummulative Calculations in side Query.

    Hey there,

    May it is so easy but when dont know so much diff. i would like to ask about the cummulative field in a query.

    i have a table with fields.

    Complaints, No of times.

    so want to calculate the cummulative values and cummulative % for Prateo Analysis.



    plz advise.

    thanks

    zee

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,629
    This is aggregate calculation. Use a Totals query for this.

    Build a report using Grouping & Sorting with aggregate calcs.

    Access Help has guidelines.

    What is Prateo Analysis?
    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. Replies: 11
    Last Post: 07-20-2011, 11:28 AM
  2. Side-by-side incorrect configuration
    By jbon in forum Access
    Replies: 1
    Last Post: 04-12-2011, 06:41 PM
  3. same recordset subreport side by side
    By novreis in forum Reports
    Replies: 5
    Last Post: 02-16-2011, 04:21 PM
  4. generate cummulative data
    By charlesdicken in forum Access
    Replies: 1
    Last Post: 01-09-2011, 10:57 PM
  5. Multiple records side by side
    By Patience in forum Reports
    Replies: 8
    Last Post: 09-01-2010, 09:17 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