My undertaking HELP!!

[Jeb]

I am starting to track shrink in a produce department for
a local grocery store. There are 35 items all together so
far that could be tracked but some are not always used. I
have created a form to list each item, give it a
category, size of container, price and unit measurement
(each or lbs) and a yes/no as to if the item is currently
in use. I have set this up with the yes/no because some
items are not used all year and I dont want to see them
all the time. With thise 35 items and their information,
I want to track each day of teh week what i made and what
I threw away. I want to also be able to store each weeks
information so i can track weekly/quarterly,half-year and
yearly totals. Does anyone have ideas? if you need more
details, email me and i can explain more.

Thanks!!!
Jeb

 

[DDM]

Jeb, please allow the blind to lead the blind for a few moments. First, note
that there is an "Inventory Control" database template in Access. You might
consider creating a test database using that template just to study it and
get ideas that might be relevant to what you're doing. You can also download
an "Inventory Management" database from Microsoft's website (it's basically
the same database template under a different name).

Now, regarding your situation. You'll need to create a "Produce" table that
captures the information you posted. Note that each item should have a
unique identifier, such as a "ProduceID" number, and that this should be the
primary key for the Produce table. You'll need a second table (call it
"Transactions" or whatever) which will contain that same ProduceID field and
will be related to the Produce table on that field. Relationship is
1-to-many, with Produce on the "1" side. The second table will also contain
a "Transaction Date" field.

Day by day, you will enter what you take in and throw out for each produce
item by ProduceID in the Transactions table. What you take in is a positive
quantity; what you throw out is negative.

Keeping track of your daily transactions like this will allow you, down the
road, to create queries that will pull out the numbers you need. But that's
later on. This should get you started. Hope this helps.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com