Running Count For Each Group in Accss Query

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Iftikhar Ayoub
    New Member
    • May 2015
    • 1
    #1

    Running Count For Each Group in Accss Query

    I have an Access Query. I want a running counter for each WBS Code group.

    Code:
    WBSCode	Required Result (In DeliverableID)
MF7375.PI00810000 	1
MF7375.PI00810000 	2
MF7375.PI00810000 	3
MF7375.PI00810000 	4
MF7375.PI00920000	1
MF7375.PI00920000	2
MF7375.PI01105000	1

    Please refer "qry_Deliverabl es" of the attachd zipped database.
    Appreciate help from experts.
    Attached Files
    Last edited by zmbd; Jul 10 '15, 06:11 PM. Reason: [z{the [CODE/] format will help preserve formatted tables... as well as being used for scripts... :) }]
    Tags: None
    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501
      #2
      1) Sorry your post was overlooked. Busy days and few hands :)

      2) As a rule, most experts and moderators will not download unrequested attachments. We tend to work on secured servers at work; thus, by local IT policy such is not allowed.

      3) What you are requesting is not uncommon, it is not however the norm for a query; however, a little more detail...

      In a query the order may change what happens in the following case:
      Code:
      WBSCode	Required Result (In DeliverableID)
MF7375.PI00810000 	1
MF7375.PI00810000 	2
MF7375.PI00810000 	3
MF7375.PI00920000	1
MF7375.PI00920000	2
MF7375.PI01105000	1
[iCODE]MF7375.PI00810000 	Do you want 1 or 4[/iCODE]
      and we'll progress from there based on your answer.

        Comment

        Previous template Next
        Working...