Greetings-
I am trying to set up a crosstab query with columns being formated as months and that will utilize start date and end date parameters that can start in one year and end in another year.
I have found that when doing this the month aggregration will include all data from the particualar month from all years (such as June data from both 2001 and 2002).
I want flexibility in my report in the start date and end date parameters.
Any thoughts how to accomplish this?
Thanks.
I am trying to set up a crosstab query with columns being formated as months and that will utilize start date and end date parameters that can start in one year and end in another year.
I have found that when doing this the month aggregration will include all data from the particualar month from all years (such as June data from both 2001 and 2002).
I want flexibility in my report in the start date and end date parameters.
Any thoughts how to accomplish this?
Thanks.