> IS there anyway of controlling this to > limit it to display just once.
Yes. Move the totals _outside_ the inner <cfoutput></cfoutput> tags. See my previous example. Otherwise, #total# will output multiple times. <cfoutput query=".." group="..."> #authorName# <cfoutput> #Books# </cfoutput> <!--- put total outside the inner cfoutput ---> #total# <br> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4