Chart in Ms Access (1 Viewer)

[Nora]

Hi Experts!

I have Membership Database. It has valid and expiry dates.

I need to generate report with chart showing monthly of total number of member (primary axis) and total amount paid (secondary axis).

Example:
Member-1,
Valid: 01 Jan 15
Expiry: 31 Mar 15,
Paid: $300 (for 3-months)

In the chart, I would like to see Jan 15 showing 1 member paid $100, Feb 15 showing 1 member paid $100 and & Mar 15 showing 1 member paid $100.

Please advise.

 

[JHB]

Then you need to prepare your data using some loops and put it into a temporary table.
The loop has to take care of the Valid and Expiry date.

 

[Nora]

Hi JHB!

Thank you for your advise

Are you able to help me with the "loops"? I've seen it somewhere in other DB but not sure how to create it.

Thank you again.

 

[JHB]

Try the attached database, open the form "CreateData" and click the button.

 

[Nora]

Thank you very much.

You have answered partially to my question

 

[JHB]

Thank you very much.

You have answered partially to my question

You're welcome, but why only partially, which part did I not answer?
I showed you how to make a loop, which was one of the question, and also (an idea of) how to prepare the data for each month.
What I left for you to do was creating a query which count the members and the sum the paid amount from the temporary table and then get that into a graph. That shouldn't be so difficult.