id's in every month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bat - 30 Oct 2005 19:47 GMT

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

Reply to this Message

Ofer - 30 Oct 2005 23:12 GMT

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

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> hi,
> I have a table like this:
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message