>
>select datepart('y',entryDate) as xYear,
>datepart('m',entryDate) as eMonth,
>count(*) as xcount
>from entries where entrystatus = 1
>group by datepart('y',entryDate),
>datepart('m',entryDate)
I just tried that and got the same results. The results of this query are just a long list (in order of oldest to newest, as it should be) of every entry in the entries table, not all of the January 2004 items grouped under a "January 2004" item.
Any other ideas?
Thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
