Liveware Publishing Support Forum

I have V.12 and am hitting a .mdb. I have time frame data for 12 items for a set of 5 properties. I can easily set up a report where for each property I get 12 columns of data (each column is a different type of cost) to print 15 years worth of data.____That is the easy part. What I want to do is to have each property print on a separate page (no problem) HOWEVER, I would like the page to be set up so I have 3 sets of 4 columns instead of 12 columns across. So I would see years 1-15 for columns 1-4, then years 1-15 for columns 5-8 and then years 1-15 for columns 9-12.____Is it possible to do this?____And as an added wrinkle, at some point if I have another set of 5 properties, (call it a different district) I would like to see these rolled up in the same format.____thanks__Fred Emmerich__

How is the data stored? Is there one record for each property with a date and a cost type and amount?____Kathleen__R&R Support

It would be like this in the .mdb:____ PROPERTY DATE COST -->11 MORE COLUMNS__ A 1/2009 500__ A 2/2009 600__ A 3/2009 700__.....__ B 1/2009 250 ---> 11 MORE COLUMNS__ B 2/2009 300__ B 3/2009 355__.....____15 years (rows) for each property.______thanks__Fred