Help understanding Append or Update in 2007

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

Here's an excerpt from a previous response on a similar question.

....the issue is that the AgreedTo price gets stored with the OrderItem. You can't simply use a Price/Cost in a Product table -- because any changes will change any historical Order info (as you have found) and you lose that info.

Click to expand...

There is more related info here.

Thanks for the reply. I have looked at the links suggested, and it seems this is not going to be as easy i had imagined with Access.
I thought it would operate in a was similar to excel, where you could determine the cell that excel used as a reference point, and could store multiple varied costs within it...
May have to do a bit more digging around!

I agree. There are many posts related to " when I changed my Product Price, all of my old Orders changed -the prices were all changed to the new Price I put in my Product table."

The general solution is to record the QuantityOfProduct and the AgreedToUnitPriceOfProduct in the OrderItem(Details) table. There are other methods, but this one seems easiest to show the concept.

You can put a Price and an EffectiveStartDateOfPrice in the Product table. Then you can determine the current Price, or the historic Price by means of the
EffectiveStartDateOfPrice....