Hi All
Given the following infor;

type start date end date percent
house 7/1/2009 9/30/2010 80
room 7/1/2009 11/30/2009 5
space 8/1/2009 6/1/2010 5


by inputting the following inform
house 7/1/09 - 6/30/10
room 8/09 - 12/09

a table would be create the following:

type date
7/09 8/09 9/09 10/09 11/09 12/09 .... 6/10
house 80 80 80 80 80 80 80
Room 5 5 5 5 5

Any one has any ideas?
thanks James