running count in a query

  • Thread starter Thread starter Benoit
  • Start date Start date
B

Benoit

I want to display a running count, but cannot figure out
how to do it.
I have 3 fields, one is a date (yyyymm), the second is a
release, the third represente the number of customer who
have install this release in that month.
What I want to display is a year graph showing the
increasing numbers of customer installing this sw release.
So I want a running count of Customer per release over
time.

thanks,
Benoit
 
I think that you need a query that shows the number of installers per month.
The following example combines the year and month, and performs the count

Select Format(InstallDate, "yymm") as YYMM, Count(InstallID) From
tblInstalls GROUP BY Format(InstallDate, "yymm")
 
Back
Top