Hello,
This is my first post. I have never worked on these types of sites before, so I apologize in advance if I do anything wrong. I do have a question that I am struggling with, but am not sure this is where I should post it. Here it goes, and redirect me to another forum if needed.
Q: I am working on a project that creates a plan using several forms and tables. On the final form when I hit the button to create the plan a series of reports are produced and updates to a lot of the ables take place. What I want to do is to copy all the data from all the tables where the "UserID and "WeekNumber" are equal, into records for the next week. The only difference is that the "WeekNumber" needs to add 1, and the "StartDate" needs to add 7 days. Any idea of how I am to pull this off?
This is my first post. I have never worked on these types of sites before, so I apologize in advance if I do anything wrong. I do have a question that I am struggling with, but am not sure this is where I should post it. Here it goes, and redirect me to another forum if needed.
Q: I am working on a project that creates a plan using several forms and tables. On the final form when I hit the button to create the plan a series of reports are produced and updates to a lot of the ables take place. What I want to do is to copy all the data from all the tables where the "UserID and "WeekNumber" are equal, into records for the next week. The only difference is that the "WeekNumber" needs to add 1, and the "StartDate" needs to add 7 days. Any idea of how I am to pull this off?