charting counts by month

[abby_md]

Hi all!

 

I have a database to log patients in a clinic with the following fields:

 

DateSeen

PatientNo

Classification (Two types of Patients: Private and Charity)

 

Is it possible to create a chart that shows the number of Private patients and number of Charity patients per month in one chart?

 

Thank you so much in advance!

-----------------------

 

And if it's not too much to ask, here's another scenario:

 

I have a parent table PatientProfile with the following fields:

DateSeen

PatientNo

Classification (Two types of Patients: Private and Charity)

 

and a Related table Consults:

PatientNo (that relates to the parent table)

DateOfConsult

ConsultType (InPatient or Outpatient)

(so each patient can have several consults with varying types)

 

Is there a way for me to tally PER MONTH the number of the following and put it in one layout:

Total Number of Private Patients

Total Number of Charity Patients

Total Number of InPatients and broken down into:

     Private InPatients

     Charity InPatients

Total Number of OutPatients and broken down into:

     Private OutPatients

     Charity OutPatients

 

Thank you again

[comment]

I am afraid that's too many questions for one thread. Even your first question has several issues, none of which is exactly trivial:

1. How to summarize records by (calculated) month?
2. How to produce individual monthly counts by category?
3. How to show these counts as individual data series in a chart?

I suggest you study the attached file for answers to these questions. Hopefully this will also help with your other scenario.

CompareMonthlyCategories.fp7.zip