No, I need the 20 again, because there is no change in stock. I always need the stock for each day, even if there was no change. It should be a 'stock overview report' answering the question: How much of article A, B, C,... was on stock for a certain period (week, month, etc.).
Regards mapd...
mapd
Last Activity: Dec 13 '07, 07:47 AM
Joined: Nov 28 '07
Location:
-
I did that, and got all the days for the month, but this is my output:
artnr ....|01.11.07 | 02.11.07 | 03.11.07
A ........| 20 ........|...... .........| 35..........
B........ | 5 ..........| 15......... |.25 ........
I have no data for the 02.11.07. Because i have no moving for article A on that day. How can i calculate this? That's why i asked.
Regards mapd...Leave a comment:
-
If I' d use a crosstab query, I' d have days missing. Remember the table in my first post:
artnr ....|01.11.07 | 02.11.07 | 03.11.07
A ........| 20 ........| 20 .........| 35..........
B........ | 5 ..........| 15......... |.25 ........
I have 20 pcs of article A on 01.11.07. I have no ins/outs on 02.11.07 so i need to report 20 pcs of article A again. A crosstab would not show me the 02.11.07 for article A. ...Leave a comment:
-
And how can i calculate the stock for each day?
Regards mapd...Leave a comment:
-
Stock report
Hello Forum!
Here is my problem: I have a table called TblArticle (artnr, comment) and a table called TblArticlemoves (autoid, artnr, quantity, date). Now I need a report that looks like the following example:
artnr ....|01.11.07 | 02.11.07 | 03.11.07 | 04.11.07 | 05.11.07 | ...
A ........| 20 ........| 20 .........| 35.......... | 45 ........| .........15 | ...
B........ | 5 ..........| 15............
No activity results to display
Leave a comment: