Search results

Lagolt and jdraw, I highly appreciate your feedback. The point is that this database is for storing procurement information for production. Here must be stored info about purchase orders, pending purchases, quotations form suppliers, the purchase, and the out put. We are not going to resell...

I made it without Dsum:rolleyes:. Just made a query based on those 2 tables, summed the [out qty] in design view of the query and deducted it from [in qty]. Now I can see the qty on hand of only those records that had [qty out], but those that were received but did not output yet I can't see. I...

thanks. I will try

Thanks for your feedback. I don't figure out anything about SQL. I would like to try option with Dsum().

Re: Hello, welcome to the forum That's clear. But for that I must Sum the shipped qty in the second table than deduct it from Received qty from the first table. 1st table Products IN Qty tires - 10 psc 2nd table Out Qty date 2 psc 14/11/2013 7 Psc...

I am a little bit new to access. I have a table where I am registering data about goods purchased. Now I want to make another table related with it where the data about output of those goods will be registered. For example: received 10 tires via particular invoice, out 5 on 20/11/13, and 4 on...