So I have a data set that will end up being huge when all said and done...however I am trying to figure out how to easily create a type of "waterfall effect" with this data table. I have a list of accts and have already calculated the number of months between to dates, number will be anywhere between 0 and 124 and this number identifies how many times this record (row of data) needs to be repeated in the data table. previously before we had this many months of data we just created a query for each origination month and was able to append those queries in the end...etc. But I am trying to do this a more effecient and easilyrepeatable way......any help or suggestions on how to accomplish this would be great!!
... View more