Prob a really simple answer

[Hayley78]

Hello Everyone!

I am a very basic user to access, as I am trying to teach myself. (my employeer is to cheap to send me on a course), But I am Having problems on now finding to answer to my now questions.

I am working on a Stock control database. and come across a problem which I've been trying to solve for months now.

I have a table which shows what is in stock, quantity, price per unit. I want a form, where the user and access and just add the number they have used or received. I need to know how to do the sum so it updates the tables.

Please remember how stupid I am, and explain in simple terms for me!!

Thank-you so much, in advance!

Kind regards

Hayley

 

[koresnordic]

You need to create a table that holds the data they have input. This will probably be just the product code and the quantity. Now create a query. Select the new table you have just created and your stock level table. Select the menu option "Query" and change the query type to "Update query". Now double click on your product code (in the main stock level table), to move it down as a field, and do the same for the stock level field. Set the criteria field for the product code to be the product code field in your new file (you may have to go via the build option - on the right click menu). This will select the line that matches any entry in the new table. Make the "update to" part of the stock level equal to [original stock level] - [adjustment], where [original stock level] and [adjustment] are the fields you use. Create a form, linked to the data table you have just created, and add a button that runs the query. When they click the button, the file will be updated. You may want to create another query to clear the new data file (another story - if you want more details contact me and I can send you an example databse).
Hope this helps