Search results

Aloha after a long time, I made a piece of code in VBA and not for all the storehouses, but for those that belongs in the same country. The code doesn't update the db, it shows only the trunsactions in the Immediate window in VBA. I want a second opinion about the code. I attach it.

Yes, I believe you are right... it's maximum

Well, there are some rules, if the storehouse is negative then obtain products from the storehouse with the minimum positive value and this storehouse belogs to a city of the same country. If there is not a city of the same country then go to another country. First i thought to run balances...

What do you mean saying the bussiness rules? Give me an example...

Thank you for your concern, i will try to make the query using what you wrote. The purpose of the query is to equally share the products between the storehouses. The storehouses which have a surplus of the product, give to the storehouses which have shortage. The storehouses which have surplus...

Thank you for your answer. When you say to use the totals button what do you mean? Well i've tried with sum but nothing...Maybe i didn't say clear enough what i want to do. I will take an example from my database: For product A: In LONDON the difference is -5 In PARIS the difference is 14 In...

Aloha, it's my first time here and the reason is because i have a problem with a query. I have a database of a storehouse. Each storehouse can be in one city. Storehouses have 5 products A, B, C, D, and E. A storehouse may have more, less or equal quantities of a product than it needs. I want...