[AccessD] Cumulative sum

Tesiny, Ed EdTesiny at oasas.state.ny.us
Mon Oct 29 10:30:02 CDT 2007


Hi All,
I think this should be easy but I can't figure it out.  To simplify, say
you have three fields, ProviderNo, ReportDate, ActiveClients.  So, if
you have 3 months of data for a provider you can create a chart plotting
each month.  Is there a way in a query to get the sum of the 3 months?  
MTIA,
Ed
 
Edward P. Tesiny
Assistant Director for Evaluation
Bureau of Evaluation and Practice Improvement
New York State OASAS
1450 Western Ave.
Albany, New York  12203-3526
Phone:  (518) 485-7189
Fax:  (518) 485-5769
Email: EdTesiny at oasas.state.ny.us
 



More information about the AccessD mailing list