SELECT SUM(currency_column) as total
FROM whatever
------------------------------------
Mark Warrick - Fusioneers.com
Email: [EMAIL PROTECTED]
Phone: 714-547-5386
http://www.fusioneers.com
http://www.warrick.net
====================================
> -----Original Message-----
> From: Alii Design [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 12:32 PM
> To: CF-Talk
> Subject: Sum Total
>
>
> OK I have a table with multiple records each with a currency field, how
> would I output the total $ of all the records.
> Rich
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
