Question on a small inventory database

[Guest]

Hi All, I am in the process of setting up a simple database to manage the
range of items which we carry as consignment stock. I have set up individual
tables to list the item codes, the stock at the beginning of the month, sales
during current month, receipts, and finally what stock remains at the end of
the month. Question I have is what is the best possible way to ensure that
the the stock lying at the end of a month, automatically becomes the opening
stock for the succeeding month? Is it possible to set up an update query to
change the opening stock figures to the end of the month figures, while
nulling the end of month figures automatically ? However, if I fail to run
the update query at the beginning of each month then this would create a
problem. Perhaps a macro could be set up to make the update query auto-run on
the first working day of each month..
Please help this novice user.

Regards

KD

 

[Jeff Boyce]

Setting up a "table-per-month" sounds like ... a spreadsheet! Access is a
relational database ... you can set up ONE table.

If one of the 'facts' you need to know (either to report on or to process
your info) is what date something happened, add in a DateSomethingHappened
field.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/