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