keeping inventory on databases

M

Mico

I have a few hundred items that get counted every day. I have all the
products listed in a table with a field for SuppliesOnHand. Now, what I want
to do is have it so that each day if I count Brand X I can put in the
quantity on hand for that day.

Also I want it to know that if I had 14 yesterday and 11 today, that I
consumed 3 in one day. So I can then run a report based on usage.

Yeah..uh...that's just not going to happen with Access, is it? I'm going to
need special software right?
 
R

Roger Carlson

Frankly, this is a huge question.

First, you need to start with a good data model. By this, I mean your
tables and relationships. Access has a design wizard that creates an
inventory control system. Try creating one and spend some time figuring out
how it works. The data model may not be perfect for your needs, but it's a
start. Here's a site where you can find some others:
http://www.databaseanswers.org/data_models/index.htm

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top