MS Access – Annual Inflation on Price Lists

Hi

I have an inventory database. Each item is given a price based on the lowest price paid during the year. Thus, I have a query called “Product Prices” which lists almost all products and the lowest price during the year (some products weren’t purchased and therefore have no price yet).

However, when the next year starts, I need to adjust all those prices according to inflation. I’m not concerned with what I actually paid for the items, but rather what they are worth (or should be worth) today. Thus, I need to adjust for inflation.

I’ve been struggling a while trying to figure out how to accomplish this so any help would be great!

Cheers