Sorting by year

[User Name]

Is there a way that I can manipulate data in pre-existing queries and crosstab queries by allowing the user to pick a variety of years they want the data to come from. Lets say a report is generated from a crosstab query that shows the number of policies there are in relation to the age and sex of a client per type of policy for every year since 1971. I want to allow the user to be able to generate a report with only the years they want to show or an option of all of the years. Does anyone have any suggestions. I got it to work for only single years using regular queries and using the criteria field to ask the user to pick a year but I need to be able to allow the user to pick a variety of years and I need to figure out how to do it in cross tab queries without altering the preexisting information. If you have any ideas, please help me out here.

 

[dcx693]

As I mentioned in this post you should create a form where users can select the years. Checkboxes or listboxes might work best since you might have some discontiguous years like 1998, 2000, 2002.