I run a very small cottage industry making and selling handmade cards. I've created a database (Access 2010) to manage this, which holds details of my cards (400 ish), all my sales, delivery info, invoice templates, etc. I've decided it's time to increase the prices slightly (probably by 50p per unit) as they've been the same for over 5 years.
I need advice on how to increase them throughout the database; however, I have reports I run to show, for example, the total sale of cards to my local farm shop, folksy, etc. If I increase my prices from, say, 1st November 2016, I need these reports to show sales totals prior to my price rise as well as showing current sales.
Can anyone help please? Annie