create chart subscribers per month?

[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

 

[John W. Vinson]

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?

Sure, if your table is correctly structured.

Use a criterion on the date field of

BETWEEN DateAdd("yyyy", -4, Date()) AND Date()

and add a calculated field

SubMonth: Format([datefield], "yyyy-mm")

Make it a Totals query grouping by SubMonth and counting records. Base your
chart on this query.

John W. Vinson [MVP]

 

[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?

Sure, if your table is correctly structured.

Use a criterion on the date field of

BETWEEN DateAdd("yyyy", -4, Date()) AND Date()

and add a calculated field

SubMonth: Format([datefield], "yyyy-mm")

Make it a Totals query grouping by SubMonth and counting records. Base your
chart on this query.

John W. Vinson [MVP]

Thanks John - will see if I can do this!

Cheers

Geoff