create chart of subscribers per month?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

Geoff Cox

Hello,

I have a database for subscriptions to a web site which has the date
on which each application to join was made etc etc.

Can I easily create a chart of the number of people subscribing each
month for the lasr 4 years?

Cheers

Geoff
 
This should be possible. Do you want the number who actually create a
subscription or do you want the total number of subscribers during the
period. For instance if I subscribed in Jan for one year, am I counted only
in Jan of 2007 or in every month Jan-2007 to Dec-2007?

If you need more help, you might want to provide your significant table and
field names and types.
 
This should be possible. Do you want the number who actually create a
subscription or do you want the total number of subscribers during the
period. For instance if I subscribed in Jan for one year, am I counted only
in Jan of 2007 or in every month Jan-2007 to Dec-2007?

If you need more help, you might want to provide your significant table and
field names and types.
Click to expand...

Duane,

I am just interested in seeing how the subscriptions vary throughout
the year so for each year I would like to take the letter-date field
(date/time type) and see how many letters are received in January,
February etc.

Cheers

Geoff
 
Does this SQL provide the values you want to graph?

SELECT Year([Letter-Date]) as Yr, Month([Letter-Date]) as Mth, Count(*) as
Subscriptions
FROM tblNoNameGiven
GROUP BY Year([Letter-Date]), Month([Letter-Date]);
 
Does this SQL provide the values you want to graph?

SELECT Year([Letter-Date]) as Yr, Month([Letter-Date]) as Mth, Count(*) as
Subscriptions
FROM tblNoNameGiven
GROUP BY Year([Letter-Date]), Month([Letter-Date]);
Click to expand...

Sorry Duane, but how do I use the above?

Cheers

Geoff
 
You open a new query and go to the SQL view. Paste the SQL statement into the
window and correct any field or table names that are not correct and then
view the datasheet. If you get an error message, fix the query or come back
here with table and field names, error messages and any other significant
information.
--
Duane Hookom
Microsoft Access MVP


Geoff Cox said:
Does this SQL provide the values you want to graph?

SELECT Year([Letter-Date]) as Yr, Month([Letter-Date]) as Mth, Count(*) as
Subscriptions
FROM tblNoNameGiven
GROUP BY Year([Letter-Date]), Month([Letter-Date]);
Click to expand...

Sorry Duane, but how do I use the above?

Cheers

Geoff
Click to expand...
 
You open a new query and go to the SQL view. Paste the SQL statement into the
window and correct any field or table names that are not correct and then
view the datasheet. If you get an error message, fix the query or come back
here with table and field names, error messages and any other significant
information.
Click to expand...

Brilliant Duane!

Got it working and it gives the numbers per month.

Thanks and Cheers,

Geoff
 
Back
Top