1
Hello!
I need to make a query that returns the weekly balance of certain products in stock. For example:
Ano/Semana | Saíram | Entraram | Saldo ______________________________________ 2015/01 | 4 | 10 | [Entraram] - [Saíram] 2015/02 | 7 | 2 | ([Entraram] - [Saíram]) + Saldo da linha acima
And so did the records. Always taking the result of subtraction of the products that came in with the products that came out and adding with the balance of the record immediately above.
I have no idea where to start...
Dude, I tried to format your table. Since I was a little confused I don’t know if it’s right, if I’m wrong let me know that I undo the editing =)
– Jéf Bueno
That’s it! Thanks, it’s my first question to the site...
– Gabriel Brunichaki
It’s I saw it’s your first question. Quiet, in time you get the hang of it.
– Jéf Bueno