Hi All,
i have a table with certain parameters in, and I need to update it in a monthly basis with new costs. Basically, its a list of component costs which change on a monthly basis, and the query/report needs to pull the latest version. But, the old costs need to be kept for legacy/comparison purposes.
TblMbM Layout (titles)
-Unique_ID
-title
-code
-Feb Cost
-March Cost
At the moment, there are no costs in the march column, but i know next week i will need to update tblMbM with the latest costs.
If anyone could help me out, i am relatively new to Access, but have been using Excel for a number of years and appear to be out of my element!
Regards
J
i have a table with certain parameters in, and I need to update it in a monthly basis with new costs. Basically, its a list of component costs which change on a monthly basis, and the query/report needs to pull the latest version. But, the old costs need to be kept for legacy/comparison purposes.
TblMbM Layout (titles)
-Unique_ID
-title
-code
-Feb Cost
-March Cost
At the moment, there are no costs in the march column, but i know next week i will need to update tblMbM with the latest costs.
If anyone could help me out, i am relatively new to Access, but have been using Excel for a number of years and appear to be out of my element!
Regards
J