price changing problem.

[shod90]

Dear Gents,
I faced a big problem when a price of one of my products was changed on my database , All reports are generating results for the new price !! .. Example to be more clear.
On 1st of October the cheese was 12$ and now the cheese 13$ , All the reports generating that the cheese was sold with 13$ even 1st of October .. How can i control this problem ??

[June7]

Options:

1. save price in orders table, will probably require some code - create Price field in table and run an UPDATE query to populate with the original price and use code to save Price in future records

2. create a new record in products, add a field IsActive and set the old record as not active, apply filter in combobox so the inactive product records are not available

[orange]

Here's a link that may be helpful.
Price change issue.

[ArviLaanemets]

Create a table tblPriceLog: PrlID, ArtID, PriceFrom, Price;
Create a function udfPriceByDate(parArt, parDate), which returns price for article/service at given date from tblPriceLog.
(the function must be the analog for query like "SELECT TOP 1 Price FROM tblPriceLog WHERE artID = parArt AND PriceFrom <= parDate ORDER BY PriceFrom DESC")

In your p.e. Orders table, remove the Price field - you must have ArticleID and sale/purchase date there instead;
In your forms, reports, etc., you can use unbound controls to display the price, using udfPriceByDate() function.