Recent content by NumLock

With the mutations I just add products to different departments. So I have a overview what products a department used. How do I need to add a Stock quantity and how I am able to add new stock? Is it possible to calculate the Stock with a Dsum?

Ok I got it almost working now :) I can add products to departments and I can generate a report that is sorted by Department name en Product ID. My only question is how can I add a quantity that I have default in stock. And how do I need to connect it with my query for the mutations? And when...

Thx, I translated my database to English :)

I translated it for you in English When I can add/remove products to departments I need to add suppliers en price but that's easier.

It did not work :) I made a query that will calculate the quantity but the query is calculating everything in the Mutations for each Product table. I need a way that it will only calculate for each product ID.

I think I got it working now :) I used a query that will use SUM And if I want to add products to a department i need to fill in the form -2 and if i want to add products back to the stock i need to fill in a positive number. Edit It doenst work It will count all the quantity of the records...

I made now 3 tables Products Product ID Name Discription Mutations for each department Mutation ID Product ID Department ID Quantity Deparments Department name Department Chef Telephone number But I don't know how to add the query. With the QueryDesign button? and do I need to change any...

Is it possible if you make me an example query in Access? That would help me allot Because I really don't know where to start. The only query that worked was [Mutations].[quantity]+[Products].[In Stock]. And I made a button for the query in a Form.

Haha but I am used to the Dutch version of Access 2007 :) I hope its clear what I am saying because of the translation to English. If I drop the "In Stock" field how I am able to see what I have in stock? And how do I make those calculations as you told me before? So it will automatic do -...

Thank you :) Sorry my English Access terms are not very good (im from the Netherlands). But you are saying that I need to make a: Product Table A table for products that come in And a table for products that go out

I am new to Access so can you help me with that? :) I have a Product table and a Mutation table In the Product table I can see the stock for each product And in the Mutation table I want to add product to different departments. The purpose of the database is to see the usage of product for...

Hello, I used an update query to update my stock. How is it possible to update the stock from the record that I am working in and not all the records in the same table? So the query only updates the stock from the record I opened

Hello, I'm new to Access and I need to make a stock management system. But I got some problems with adding products to different departments. I need to add products to different departments. So I can see which department uses the most paper for example. But I don't know how. I used update...