Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 22 Jul 2013 at 5:31am
you might consider using a stored proc but you can also alter your view
you could much more esialy include in the column for 'current month' as defined by your week straddling in that then use that column as your way to break out the data in the report.
you can use an inner query to get the one value for each week number filtering on the currentmonth and join that back to your current data set on the week.
I can also use this formula as my 'on change of' field to get my desired result - or at least parts of it.
If Month({Data.Date}) <> Month(CurrentDate)
Then DateSerial(Year({Data.Date}), Month({Data.Date}) + 1, 1) - 1
Else {Data.Date}
What this does is, for every month prior to the current month, amend the
date to the last day of its respective month, but leave the dates for
the current month unchanged.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
