Is there an option for ...?

[Somebody]

hi

i'm trying to create a report that shows data by year but where the data repeats itself every year until the specified date. In the table where the data is, field is for the year until this amount has to be counted So if the data is set for 2011, it should be present in the report for 2009 ,2010 and 2011.
I've tried many ways to do it but the data is always sorted by the year where it would end ( ex. 2011)

Does anyone know how to create such report without adding records for every year the data should show?

thanx for your help in advance

 

[Somebody]

thanx for your help
but i found a solution to my problem using another table for the years and a dSum() with a condition between the table and the year specified in my querie

thanx again and have great week

-there is no recess in access