I've always solved that problem by looping over each year I want to output, then use a query of queries to extract the data for that year (if it even exists) and output it. Then you don't have any gaps.
There's probably a better way though. That's just my quick and dirty method. :) ~Brad -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 9:18 AM To: CF-Talk Subject: Pivot table confusion My problem is if a year had no types it has no value not even null. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
