AnsweredAssumed Answered

Count records by year by provider

Question asked by AnitaWoods on Oct 8, 2018
Latest reply on Oct 8, 2018 by philmodjunk

I have a Births table with birth records that has the following fields: DOB, baby's name, midwife who delivered the baby (Provider), and type of birth (VD, CS, VBAC, etc.).  I am trying to create a summary report to count the number of births by year for a specific midwife provider, then by type of birth, then a calculated percentage of total births. Like this:


Midwife 1

  2017   12 births

                  10 VD (83%)

                    2 C/S (17%)

  2016    30 births

                   25 VD (83%)

                     2 CS (7%)

  2015   17 births

                  17 VD (100%)

  Total    59 births

                   52 VD.... etc.

Midwife 2

  2017    19 births

  2016    14 births

  2015    25 births



I've created a calculated field in the Births table, YearCount = Year (DOB), but I don't know what to do now. I'm just a personal user with just enough FM experience to get lost, using old FM 13, so I appreciate any step-by-step help you can provide for me. TIA!

philmodjunk You've always been very helpful to me in the past.