We have an inventory database that is junk. It sort of works but .... well doesn't. We have all the fields (Chemical, Cost, Company purchased from, Employee name (who take inventory), Category, and description. We need to be able to keep accurate inventory by employee. We also will need end of month report to see employee chemical use and also one that will show starting inventory less chemicals given out plus inventory for the actual stock we have on hand. Flexibility of reports would be nice since they always seem to be asking for something new!
I have the txt I imported from this other program so you can see the data. I have actually put that into an msaccess database but manipulating ms access is not my cup of tea.
I can get much more specific if you need, just ask.