Search the Community
Showing results for tags 'loop'.
Assume following Table schema: Hi, My desired work flow Insert a date record into tbl_Inventory Count_Dates On INSERT, tigger the following: Loop through tbl_Inventory_Items - a list of each item to be counted - and insert a copy of each item into tbl_Inventory_Count_Detail, along with default value of 0 for Count of each record. This results in a record including new id, Count_Date(which triggered the event), Material_id, Material_Name, and Count (Set to 0). The purpose of this is to be able to filter tbl_Inventory_Count_Detail by Count_D
What I hope to do, is autofill a table based on submitted start and end date of a project. The routine to be developed should create a record in the Milestone table for each 6 months period the projects lasts. i, mx, dur as integer dur = Round((DateDiff("m",[SA_StartDt],[SA_EndDt])+1)/6+0.3,0) = number of records to be created For i = 0 to dur mx = i * 6 Proj_ID // Period_No // Period_StartDate // Period_EndDate // Budget [Proj_Recno] // i + 1 // DateAdd(month, mx, [SA_StartDt]) // DateAdd(month, mx+6, [SA_StartDt]) //