On Mon, 27 Aug 2007, Dennis Achá wrote:
Does anybody know how to perform mathematical calculations with the data entered into your SQLite3 tables? I'd like to get simple calculations like sums, averages, percentages, etc.. Is there a way to do this and print material afterward? If you know how, please explain how to pursue this task. Thanks
Dennis, Did you look at the syntax pages for aggregates? You can do SUM(), COUNT(), AVG(), and combine them to do things such as percent = (value/SUM()) * 100. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
