Hi, I am after some general advice. I have an access application with about 20 related tables that allows the organisation to estimate construction projects and then track the progress of the project over time (weekly).
At the moment the tables do not have any audit trail or historical information. I will try and explain my requirement with an example.
I have a table called ContractActual that has a multiple key. Included in the table are the following fields: -
WeekEnding
% Complete - Brackets
% Complete - Fixings
% Complete - Finishing
% Complete Value (calculated from an estimate and applying the total % complete.
At the moment the rows are UPDATED so the Week Ending changes each week. What I want to do is Image the rows and create new ones for each week (without having to rekey all the information.
Does access have an auto image facility?
Sorry this is not very clear. Ultimately i want to be able to report on progress over time (weekly) on project progress.
Thanks
At the moment the tables do not have any audit trail or historical information. I will try and explain my requirement with an example.
I have a table called ContractActual that has a multiple key. Included in the table are the following fields: -
WeekEnding
% Complete - Brackets
% Complete - Fixings
% Complete - Finishing
% Complete Value (calculated from an estimate and applying the total % complete.
At the moment the rows are UPDATED so the Week Ending changes each week. What I want to do is Image the rows and create new ones for each week (without having to rekey all the information.
Does access have an auto image facility?
Sorry this is not very clear. Ultimately i want to be able to report on progress over time (weekly) on project progress.
Thanks