Hi I am trying to create query that will show the "total number of visitors we have each month".
Just now each visit creates a record with the time and date of the visit
e.g. 11/12/2010 10:05:33
I need to extract the month and year from each record and total the number for each month, (so i can see the total number of visitors for each month.)
Can you help me with this ?
Gregorg.
Just now each visit creates a record with the time and date of the visit
e.g. 11/12/2010 10:05:33
I need to extract the month and year from each record and total the number for each month, (so i can see the total number of visitors for each month.)
Can you help me with this ?
Gregorg.