Datepart in crosstab query

[Guest]

Hello All,

I have a query that provides a list of agents and their computer refresh date.
I would like to group my data by month and year. I have options to select
month or year, however I don't see any option to create a combination or
select a date part.

Thanks for any help

 

[Stephen Russell]

Hello All,

I have a query that provides a list of agents and their computer refresh
date.
I would like to group my data by month and year. I have options to select
month or year, however I don't see any option to create a combination or
select a date part.

I have computed a column of String Year - Month in the query, as well as
int year and int month so I can sort the data properly order by CoName,
????, MyYear, MyMonth

Next use that YearMonth column as your header data and your good to go.

 

[Guest]

Stephen, I'm not sure how you created the column strings or what the int
month and year means
can you provide more detail.

Thanks again