Hey,
I'm writing a stock database. Therefor I have a table with product info (primary key is the order number). I also made a form to add new products.
I made a new form where I can put amounts of incoming and outgoing products into fields. A query is needed to calculate the amount in stock of that product. But this doesn't seems to work. I tried everything I know about access (not much), so if anyone can give me some hints so I can get started again I'd be pleased. If you need my database (the one I'm making) to make my issue clear to you, then tell me and I'll post it. I also have an example of the sort of database I want (here is primary key of product table an autonumber) but I can't manipulate it properly. This might help you out maybe, so just tell me and I'll post this one as well.
Thanx in advance
Kev
I'm writing a stock database. Therefor I have a table with product info (primary key is the order number). I also made a form to add new products.
I made a new form where I can put amounts of incoming and outgoing products into fields. A query is needed to calculate the amount in stock of that product. But this doesn't seems to work. I tried everything I know about access (not much), so if anyone can give me some hints so I can get started again I'd be pleased. If you need my database (the one I'm making) to make my issue clear to you, then tell me and I'll post it. I also have an example of the sort of database I want (here is primary key of product table an autonumber) but I can't manipulate it properly. This might help you out maybe, so just tell me and I'll post this one as well.
Thanx in advance
Kev
