Tim Thiessen
tim at irwingreenhouses.com
Mon Feb 9 10:59:17 CST 2004
Hi Group! I have a table with the following data: ItemNo LotNo SeqNo Weeks WkNo 2556 401 1 3 0 2556 401 2 3 0 2556 401 3 6 0 What I need to do is to append records to the table so that the WkNo is filled in starting at 1 to Weeks-1. For example: ItemNo LotNo SeqNo Weeks WkNo 2556 401 1 3 0 2556 401 1 3 1 2556 401 1 3 2 2556 401 2 3 0 2556 401 2 3 1 2556 401 2 3 2 2556 401 3 6 0 2556 401 3 6 1 2556 401 3 6 2 2556 401 3 6 3 2556 401 3 6 4 2556 401 3 6 5 What is the best way for this to be accomplished? I'm blank at the moment. Tim Thiessen