By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

Running Count For Each Group in Accss Query

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

Expand|Select|Wrap|Line Numbers
  1. WBSCode    Required Result (In DeliverableID)
  2. MF7375.PI00810000     1
  3. MF7375.PI00810000     2
  4. MF7375.PI00810000     3
  5. MF7375.PI00810000     4
  6. MF7375.PI00920000    1
  7. MF7375.PI00920000    2
  8. MF7375.PI01105000    1

Please refer "qry_Deliverables" of the attachd zipped database.
Appreciate help from experts.
Attached Files
File Type: zip InControl Resources - Rev-02.zip (77.5 KB, 64 views)
May 28 '15 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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:
Expand|Select|Wrap|Line Numbers
  1. WBSCode    Required Result (In DeliverableID)
  2. MF7375.PI00810000     1
  3. MF7375.PI00810000     2
  4. MF7375.PI00810000     3
  5. MF7375.PI00920000    1
  6. MF7375.PI00920000    2
  7. MF7375.PI01105000    1
  8. MF7375.PI00810000     Do you want 1 or 4
and we'll progress from there based on your answer.
Jul 10 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.