Sum year in a weekreport

[Vallan]

Hello.

I have a report made from a query wich ask...

What year i want to see and what week.


Works just fine.

Now im trying to find out if its possible to make a sum ofthe year?

At the moment i have made a subreport wich sum the year but the problem is that it sum everything....(lets say i wait until tuesday to write the report then i get the monday in the sum)

I would like to make that the sum starts from the 1 january until the last date in the query.


Is this possible in a simple way?

Thanks.

Matt

 

[ajetrumpet]

what do you mean it sums everything?? if you want to start a calculation from Jan 1st of a certain year,use DateSerial() and format it if you have to. And, for the last date in the query, try using the MAX() function for the appropriate query field.