Analyst12345
New member
- Local time
- Today, 00:56
- Joined
- Feb 3, 2020
- Messages
- 1
Hi,
I am designing a new database to build regular reports on different projects.
There is a project table where data is about the particular project.
Related to that table, there are an Issue table and a status table.
Every project can have many status items and issues.
The status table and issue table will be updated every week.
I am looking for a way to create a database where the project manager pulls the information from the previous report, and updates the information for the current reporting period by creating a new record for a particular issue / status item without overriding the previous week data. This way, every week's data still exists.
I am looking for a solution that I can do with macros as I don't have a lot of experience with coding.
Thank you!
Analyst12345
I am designing a new database to build regular reports on different projects.
There is a project table where data is about the particular project.
Related to that table, there are an Issue table and a status table.
Every project can have many status items and issues.
The status table and issue table will be updated every week.
I am looking for a way to create a database where the project manager pulls the information from the previous report, and updates the information for the current reporting period by creating a new record for a particular issue / status item without overriding the previous week data. This way, every week's data still exists.
I am looking for a solution that I can do with macros as I don't have a lot of experience with coding.
Thank you!
Analyst12345