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
Bookmarks