Ah! That is it! Thanks!
-----Original Message----- From: Phillip Ciske [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 1:49 PM To: CF-Talk Subject: Re: adding query results > I swear I remember a CF function that would total a query's results. > > Like if my query returns 10 rows of grandTotal and grandTotal is a field that > contains numbers. > > You could run a function and it would add the 10 rows together so you get one > number. ArraySum? total = arraySum(yourQuery['grandTotal']) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

