Question Need advice on recording changes in data

[anniehall]

I have a small, pretty amateurish and basic database to record the greetings cards I make and sell. I have a field which stores the price of each card.

Is it possible to change the price of an item today (say) and still be able to run a query/report showing it at its former price?

Any advice and hints would be most welcome.
Annie

 

[PaulO]

You need a TABLE to store Prices and Price Change Date Points

Fields:Card; Price, Effective Date
e.g.
Birthday; £0.75; 01/02/2012
Birthday; £0.80; 15/02/2013
etc

Then build a SUM Query using the MAX 'Total' function on Effective Date to get a current price list for all Cards. Use the MIN function to get the earliest price for all Cards. Etc

 

[anniehall]

That's great. Thanks for the info. I'll give that a go and post back later.
Annie