-
count for each month
I have 2 tables in Access 2000 : Members and Messages
I get all the members.Id for a category with a Procedure
List_Members_3 >>>
SELECT Members.Members_Id
FROM Members
WHERE Members.Cat = 3
then I want to get all the Messages of the Members for january 2004
SELECT Count(Messages.Id) AS CountOfId
FROM Messages INNER JOIN List_Members_3 ON Messages.Id = List_Members_3.Id
GROUP BY Year([DateMessages]), Month([DateMessages])
HAVING (((Year([DateMessages]))=2004) AND ((Month([DateMessages]))=1));
I get one row = Count
how can I get 12 rows for each month ?
Month([DateMessages])=(1 to 12)
-------------------------
and how can I avoid >>>
SELECT Count(Messages.Id) AS CountOfId
FROM Messages INNER JOIN List_Members_3 ON Messages.Id = List_Members_3.Id
with sommething like >>>
SELECT Count(Messages.Id) AS CountOfId
FROM Messages Where Messages.Members_Id IN (SELECT Members.Id
FROM Members
WHERE Members.Cat = 3)
thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|