Here is a new version. I have modified the queries to return only the weeks between the DeliveryDate and today's date.
Calculate weekly overview query
-
- Administrator
- Posts: 78443
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Calculate weekly overview query
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
Hi,
I have a filter to the current week. The only thing is. If we start a new product in 2016. My report is from 2013....
I have a filter to the current week. The only thing is. If we start a new product in 2016. My report is from 2013....
-
- Administrator
- Posts: 78443
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Calculate weekly overview query
Do you mean that you want to enter a product NOW with DeliveryDate in 2016?
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
Sorry I didn't saw your message. I have downloaded the database and I think I can manage! Thanks a lot for your help and sorry for the difficult explanation .
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
I have implemented it in our database but I have another issue. Now I use the modified queries to return only the weeks between the DeliveryDate and today's date. If the stock is 0 the calculation after the last delivery must stop also. Is this easy to do? If the total sum of pallets is 0 the calculation must stop showing more weeks. Maybe It is easy to choose for a new field in the products table "LastDeliveryDate" and filter between the 2 dates?
-
- Administrator
- Posts: 78443
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
Ok Thanks I'll try the extra date field.
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
Hi Hans,
It worked! Thanks!
Is it possible to get the last records of the results on the report in a new (total) field at the below of the report? I want to calulate with the total pallets at the end of the report. Sum is not working. Any ideas?
Kind regards,
Michiel
It worked! Thanks!
Is it possible to get the last records of the results on the report in a new (total) field at the below of the report? I want to calulate with the total pallets at the end of the report. Sum is not working. Any ideas?
Kind regards,
Michiel
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78443
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Calculate weekly overview query
If you want to duplicate the last (most recent) number of pallets, place a text box in the Report Footer section with Control Source =[Text18] where Text18 is the text box in the detail section displaying the number of units.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 42
- Joined: 28 Nov 2013, 13:09
Re: Calculate weekly overview query
Thanks! It worked. I thought I had tried that. Thanks again for your quick reply!