FIltering a crosstab query on a date- urgently need hlep

I am creating a report based on a crosstab (BodyPart). This crosstab counts the number of incidents for each body part by month. However the data is for different years and I would like the user to be able to specify which year they are running the report for. The date is in the field incident_date (format dd/mm/yyyyy) and the filter criteria should only be on the year part.

I would also need the report to dynamically list the year selected in the header of the report and I do not know how to do this.

Could anyone help me?

re: FIltering a crosstab query on a date- urgently need hlep

Hi,
To obtain only the year you have to use the function Datepart("yyyy",Mydate) as a column in your query!

And to filter the years from the report! It's a bit dificult! You can do it using a form that open a report!

Or more sample using your own query but show it in Pivot table View! There is functionality to choose what to see! :)