You can't really use currentrow with group - it throws it off. Best thing to do in those cases is create your own counter, that you refresh each time the group is looped on, and use that to do MODs on.
That said, to do two columns the way you want, the manual counter bit won't work either. I'd suggest either doing your cfoutputs the same way you are now, but beforehand, and keep count of how many rows are present for each state, and then when you're doing your display, you'll know at what point in your manual counter for each state you need to start a fresh column. Either that way, or do a ValueList() on your state field in your query, loop over it and keep counts of how many times each state appears in the list, and use that to determine when to start fresh columns. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
