I am trying to create a stock management system. I have created a table with the following fields

ProductID, Date,Product name, opening stock, Purchase, desptches, closing stck.
Now my problem is how do I make the closing stock of the previous day or record be automatically transfered as the opening stock of the current day or record

Heelp

Bright

Bmulenga

__________________
Bmulenga

I would create a query that listed the TOP 1 for the table based on the date, and then take the closing figure and create a new record for the current day and paste that to the opening column. Who is responsible for doing this each day?

OR I would do this when the closing figure was entered. Check for Fridays and you are set. How much help do you need with the code?


mmcdonal