Hello,

I'm new in Access query with crosstab.

I need to create a report that the user will enter the start date and the report will show the stats for years from the start date and the next 9 years too. For exemple if user choose "2002" the report will show stats with years as column 2002,2003,2004,2005,2006,2007,2008,2009,2010,2011

So, i have to use crosstab, my problem is the column's name, the column name will change depending the entry of the user...

How should i make my query and my report to display the the first year as start date(choose by user) and after increment the years by one for the next 9 years ??

Thank a lot for your help

Pascal