id's in every month

B

bat

hi,
I have a table like this:

id date place

and i need a query like this:

place january february march .........

which shows me the id's in every month for every place.

thanks
 
O

Ofer

What about the year of the month? do you want to sum the id per month?

You need to use a CrossTab Query, but youll need to sum on the id

Try this
TRANSFORM Sum(TableName.Id) AS SumOfId
SELECT TableName.Place
FROM TableName
GROUP BY TableName.Place
PIVOT Format([DateField],"mmm") In
("January","February","March","April","May" ,"June", "July", "August",
"September", "October","November","December")
 
Top