Results 1 to 2 of 2
  1. #1
    Thomas1 is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Sep 2015
    Posts
    2

    Angry Count the Count Query - Dsum NO-GO

    I have a Query with two Fields: UnitPrice and a Partition Calculation.



    Partition computes a Bin Value forthe Prices: Prices Range from $40 to $45.

    ON the unit price field, I use theaggregate function and "Count"

    I get out put that looks like this:

    CountofUnitPrice: Bin Values: PartitionFunction(bla,bla,bla)

    3 $40- $41
    6 $41- $42
    0 $42- $43
    2 $43- $44
    1 $45- $45


    Now: How to I get a cumulative valueof the "CountofUnitPrice" ??????


    IE: Next column shows: 3 This is what I need so I can finish this project.
    9
    9
    11
    12



  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    you can do running sums on report output, it's incredibly clunky to try to do it in queries. Is there a specific reason you need to do it in a query as opposed to a running sum in a report?

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

Similar Threads

  1. Replies: 2
    Last Post: 06-30-2016, 06:38 PM
  2. Year Count and Month Count Same Query
    By NateSmith in forum Queries
    Replies: 1
    Last Post: 05-13-2015, 08:23 AM
  3. Replies: 6
    Last Post: 11-05-2014, 03:00 PM
  4. Replies: 2
    Last Post: 04-15-2014, 01:59 PM
  5. COUNT Group Count Records COUNT FUNCTION
    By PMCOFFEY in forum Access
    Replies: 9
    Last Post: 11-09-2012, 09:40 PM

Tags for this Thread

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