Hi All,
I am trying to do a running count on a query I have made. Below is the datasheet view of the query, grouped by months, with a count of items which came online during that month. I would like to do a running total of this count. I am having trouble figuring out how to use the dsum() function so any help would be appreciated.
<CAPTION></CAPTION>
<THEAD>
</THEAD><TBODY>
</TBODY><TFOOT></TFOOT>
I am trying to do a running count on a query I have made. Below is the datasheet view of the query, grouped by months, with a count of items which came online during that month. I would like to do a running total of this count. I am having trouble figuring out how to use the dsum() function so any help would be appreciated.
| Start Date By Month | Count Of New Items |
|---|---|
| October 2008 | 1 |
| November 2009 | 2 |
| January 2010 | 2 |
| February 2010 | 3 |
| March 2010 | 2 |
| April 2010 | 7 |
| May 2010 | 6 |
| June 2010 | 1 |
| October 2010 | 2 |
| November 2010 | 1 |
| December 2010 | 5 |
| January 2011 | 1 |
| March 2011 | 1 |
| April 2011 | 1 |
| February 2012 | 1 |
| April 2012 | 2 |
| November 2012 | 1 |
| December 2012 | 2 |
| January 2013 | 1 |
| March 2013 | 1 |
</THEAD><TBODY>
</TBODY><TFOOT></TFOOT>
