Calculate weekly overview query

[HansV]

Here is a new version. I have modified the queries to return only the weeks between the DeliveryDate and today's date.

weekly.zip

[mwal]

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....

[HansV]

Do you mean that you want to enter a product NOW with DeliveryDate in 2016?

[mwal]

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 .

[mwal]

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?

[HansV]

I'd try that, yes.

[mwal]

Ok Thanks I'll try the extra date field.

[mwal]

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

[HansV]

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.

[mwal]

Thanks! It worked. I thought I had tried that. Thanks again for your quick reply!