I have a query which has been built to return information of the sum of records during a user specified period (criteria between startdate and endDate which user preselects)
I want to show rows of sums of records for each succesive whole year beginning from a datevalue "BeginDate" which is contained in a related field right up to todays date.
So if a BeginDate value would be in Aug'98, it would provide me with:-
sum between Aug98 and july99
sum between Aug99 and july00
sum between Aug00 and july01
but no further as there is not a complete year
There are a number of beginDates but each one is related to a different group of recrds
I suspect having to do a loop and increment start and end date by 365 days whilst todays date - startdate is less than 365 but how do I then get the results and display them in a query?
Thanks
I want to show rows of sums of records for each succesive whole year beginning from a datevalue "BeginDate" which is contained in a related field right up to todays date.
So if a BeginDate value would be in Aug'98, it would provide me with:-
sum between Aug98 and july99
sum between Aug99 and july00
sum between Aug00 and july01
but no further as there is not a complete year
There are a number of beginDates but each one is related to a different group of recrds
I suspect having to do a loop and increment start and end date by 365 days whilst todays date - startdate is less than 365 but how do I then get the results and display them in a query?
Thanks
