for loop in table to create another table

melghandour89 — Thu, 26 Jan 2017 20:31:13 GMT

Hi all,

I need help in creating asset's future depreciation

I'v table named 'AssetsInfo' Which contain this rows

Assets No.	Year	Month	Amount	DepValue	Dep-End-Date
287195	15	09	1890	15.75	09/30/2025
287195	16	11	500	4.17	09/30/2025

I need to create depreciation table by using above table .

what I think to do for loop from first row (Year-Month) to second row (Year-Mont) then from second row to Dep-end-date with given amount

the achieve table that need to create as a below

Assets No.	Year	Month	Amount	DepValue
287195	2015	10	1890	15.75
287195	2015	11	1890	15.75
..	..	..	..	..
287195	2016	11	500	4.17
..	..	..	..	..
287195	2025	09	500	4.17

Can Any one help me You will find in the attached file the qvf

Re: for loop in table to create another table

MarcoWedel — Fri, 27 Jan 2017 00:46:36 GMT

maybe helpful:

regards

Marco