Running Count of a group

[Jordan2000]

Hi there,

I got a question regarding te following.

I am trying to make a running count in a query
That should look like thise.

Year Qourter Company Customers Wholesale Value Running Count
2009 Q1 15103 Customer 1 € 7.027,64 1
2009 Q1 15103 Customer 2 € 5.205,01 2
2009 Q1 15103 Customer 3 € 2.905,95 3
2009 Q1 15103 Customer 4 € 1.803,03 4
2009 Q1 15104 Customer 1 € 1.756,50 1
2009 Q1 15104 Customer 2 € 940,80 2
2009 Q1 15104 Customer 3 € 846,25 3


But I can't find a Function in Access that helps me to do this,

Can you help me to do this in a query

 

[Rabbie]

This link should help you achieve what you want.

 

[Jordan2000]

Thanks,

It take a wil to incorperate it but now it is working fine.