By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,262 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

FIltering a crosstab query on a date- urgently need hlep

P: 7
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?
Sep 4 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
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! :)
Sep 4 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.