id's in every month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Back
Top