Search results for query: *

Indeed, it updates all the records in that colum. My Outstock form has a query which updates the Inventory table. Inventory table - [wharehouse], [article number], [receive date], [expired date], [InStock], [OutStock], [Total] I append my New InStock Items into the Inventory table and my...

Sorry for the late respond. At some point I got the result as docmeizie suggested. I have a main and sub form. I had to work with an update and append query. If I update my record in a recordset, the program updates the whole colum. Instead I need to update the first record in my recordset. Do...

docmeizie, earlier you suggested to make a query where it shows the maximum age of the products. I tried to execute a query with the Dfirst function, but i get an error. Which function do you susggest

Yes, indeed it is important to know which product goes first out of stock. The out stock is based on first in first out principle, which of course is bound to a receiving date. I do not work with the expiring date of the product just receiving date. To substract my out stock from my in stock I...

Hi, thanks for the reaction. The database is just to know the items that I have in stock. It's a wharehouse database. Items are coming in and going out. Based on my oldest date I have to select those items to go first out of the wharehouse. And this is where i'm stock. I can append my incoming...

How can I substract a stock item from the total stock of that same item from my oldest date ? Secondly, if my stock from my oldest date is not enough, how can I substract from my second oldest date ? E.G. If my stock article Crunch on 1 dec 2003 = 20, and on 15 dec = 5. On the 20th I will use 30...

Got it, thanks

SQL view INSERT INTO INVENTORY ( WHAREHOUSE, ART_NR, MOB_NR, PRODUCTION_DATE, EXPIRING_DATE, QTY ) SELECT INCOMING.WHAREHOUSE, INCOMING.ART_NR, INCOMING.MOB_NR, INCOMING.PRODUCTION_DATE, INCOMING.EXPIRING_DATE, INCOMING.QTY FROM INCOMING; THANKS

Hi, Thanks for reacting. My append query must place my new records from my incoming table to the inventory table. Updating my fields does not succeed either. A wharehouse receives and distribute articles (articles that I have in Stock). My inventory table is this e.g. Inventory table...

Hi, I'm developing an wharehouse - inventory access database. I have an inventory table (articles, wharehouse, production date, expiring date, Qty ), an incoming and an outgoing table. The articles leave the wharehouse based on the fifo system. My products have an production date and an...