Crosstab Query

[Simon]

I have a crosstab query that shows the products i sale with the number
i have sold for each day.

instead of showing the sales for each day i would like to show sales
dor each months.

How do i show it my month


Thanks

 

[Allen Browne]

In query design view, enter this into a fresh column in the Field row:
TheYear: Year([SaleDate])
Replace SaleDate with your actual field name.

In the next column:
TheMonth: Month([SaleDate])

You can now group on these fields instead of on each date.