Do you have an example of what you mean? Maybe I've been staring at it too long but i just don't see how to populate non existent data.
On 9/17/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > 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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
