>>in succession, but the <CFSET SubTotalTaxable> tag only shows the first >>record
The way it's written, a new value for subTotalTaxable is set with every iteration. >> <CFSET SubTotalTaxable = #OrderTotal# + #ItemPrice#> If I understand you, don't you want to add a value to the existing value contained in subTotalTaxable? <cfparam name="subTotalTaxable" default=0> <cfloop> <cfset subTotalTaxable = subTotalTaxable + itemPrice> </cfloop> FYI: ditch the extra #'s. -Craig ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm