Saving Old Values...

[Kelsey]

I am working with an inventory system. I have a form that creates current cost of final product (Labor+Material). This form is linked to the inventory table, where the prices of material get changed quite often. I was wondering if there was a way to save the "quoted" prices, as they will be different than the "up to date" prices.
Thanks!

 

[cookiegary01]

Hi,

There is a way.
You could save data to an extra "TbQuoteHistory" for example.
Due to your question, your Access design skills are average, so I'll tell you how to do it without too much programming language:
1: Create a Query that contains all the values you need, don't forget todays date (i.e. the date of change).
2: In design view of that query: save query as a "Make-Table Query". Give new table a name TblQuoteHistory
3: "Run" (not show data view) the query. The data has been sent to the new table.
4: Check the new table contents. Delete all records unless you need them.
5: Every time a price is changed, you could now add (append) that updated price to the TblQuoteHistory.

(Now it becomes more complicated: "How to do append every time")
Let me know whether you will update many prices at once, or just a few at a time.
Then I will inform you what I would do. (Unless you can come up with a solution yourself)

 

[Kelsey]

Just to clarify, I would like to have a copy of the locked in price that was quoted, and an up to date price.

 

[cookiegary01]

Create the query I mentioned including the locked price and the up to date price. A better name for the table would be TblPriceHistory.
I will get back to this when you have created the query and replied to my previous question in my previous post.