Count user per month

[weee]

View a printable version of this message! I have a table with users names and each user namd has a rs of full time & date.

How do I count the number of users for weach month?

Something like:
April 2006 (30 users)
May 2006 (12 users)
June 2006 (28 users)

[ahk2chan]

I am using MySQL, the query looks like:

SELECT count( userId ) , month( clicktime ) AS cm, year( clicktime ) AS cy
FROM `trafficstat`
GROUP BY cm, cy


That will count the number if userId in each month / year. You can put unique in front of userId field to get a count of unique user access each month.

[weee]

How it'll look like in Access?

[ahk2chan]

I think there is a Month and a Year function in Access too. Other syntax are standard SQL syntax... You may take out the single quotes and try the query with Access and see if it worked.