Hello Guys,

Right now I am tracking all the produce inventory my store throws away, along with the cost of those items, in Excel. I then use this information to produce a report on what we have thrown away each day or each week. While this is very simple, I have long terms ideas for this data (identifying trends of when certain produce is not selling, seeing how high or low produce is priced when it is thrown away, and comparing how much we have sold to how much is thrown away, to name a few) and Excel will not meet my goals.

Additionally, data entry is a slow process. Why? PRICES. We have a 28 page list, and when a user wants to enter the information they have to look through the inventory list to find the price of that item THAT WEEK. Fortunately, most of our products have set prices. My first, biggest question is this:
Can a create a list (PRICE WEEK 1) and populate it with all our inventory, and give it a price THEN the next week duplicate that list as (PRICE WEEK 2) and change only those items that need to be updated.
In this, I am hoping that I can show that on week 1 I threw away 10 pounds of celery at $1 a pound, but in week 2 I threw away 6 pounds at $1.05 a pound. It would be very important that when I create the new (PRICE WEEK) list that new data refers to this new list, and not "last weeks."

And I have no problem adapting another persons pre-existing database to my needs if one is offered! I have been looking online, but so far I am only finding DBs that track inventory, NOT any that track trash.

Thanks

I didn't find the right solution from the internet.
References:
- http://www.accessforums.net/showthread.php?t=66817
- Production Management Video Examples.

http://www.sql.ru/forum/1267698/wasted-inventory-tracker